SQL Kiwi (2/2/2012)
An article about clearly documented behaviour, and no mention of the more serious problems with COALESCE? Poor.
Now you make me curious. Which issues are you referring to? A quick Google search tells me that datatype precedence is important for COALESCE.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP