-- ZJSTS's value maybe be empty , if so then replaced it with 0. But the following statement doesn't worked for me
SELECT DATEADD(DD,(CASE ZJDTS WHEN '' THEN 0 ELSE ZJDTS END ),JFDate) AS a, JFDate   FROM  PM_JD_LCBS