Home Forums Article Discussions Article Discussions by Author Discuss content posted by John Arnott More Fun With NULL RE: More Fun With NULL
BudaCli
Hall of Fame
Points: 3384
More actions
November 9, 2009 at 4:44 am
#1076587
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