According to User , I need to replace 'N/A' as Not avaiable in place of date where date value is null.
So, can anyone help me out.
you can use below syntax for your requirement..
CASE WHEN CAST(RUNDATE AS VARCHAR(10) ) IS NULL THEN 'N/A' Else CAST(RUNDATE AS VARCHAR(10) ) End
hope this solves your problem.