• Nice one, Noticed that when you use your case statement as per below then you get the "Date is Null" results as you do not have your else statement.

    SELEC CASE

    WHEN CONVERT(CHAR(10),@MyDate,101) IS NULL THEN 'Date is Null'

    END AS MyDate

    What you don't know won't hurt you but what you know will make you plan to know better