Christian Buettner-167247 (11/9/2012)
Good question, but wrong explanation (and also wrong error message from SQL Server):The coalesce expects at least one typed NULL in order to execute and hence the error.
Simple example that does NOT contain a typed NULL:
COALESCE(1,1)
Msg 4127, Level 16, State 1, Line 8
At least one of the arguments to COALESCE must be an expression that is not the NULL constant.
.. possibly just missing the word "Not"
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.