Noel McKinney (11/3/2009)
This is the main reason I make it a habit to use COALESCE rather than ISNULL unless there's a reason I need the behavior of ISNULL.
I wasn't aware of that ISNULL property or that COALESCE does NOT truncate that way. I've been switching to using COALESCE on occasion because I understand that it's ansi-standard, but now I have an additional reason to use COALECSE.
Thank for a good question.