Good question. I missed the char(10) limitation. I did not know that COALESCE does not limit output size while ISNULL does.

coalesce(convert(char(10),@MyDate,101),'Date is Null') = not limited to 10 characters

IsNull(convert(char(10),@MyDate,101),'Date is Null') = limited to 10 characters

Now just have to try and remember this :hehe:

David