SanDroid (5/18/2011)
Carlton Leach (5/18/2011)
Another bug vote here, and another wrong answer for me.NULL is NULL...fullstop. You never know what NULL is so regardless if you insert, concatenate, stick it somewhere in the string: the whole string is (SHOULD BE!) now unknown.
My guess is anyone who got this right either ran the commands first, read the question wrong, of has bumped into this before.
Carlton.
Or has used STUFF for the 11+ years it has worked this way... :hehe:
http://www.mssqltips.com/tip.asp?tip=1026
I can say the documentation used to be better.
That link doesn't say what STUFF does with a NULL last argument. So how can you say it tells us it worked that way for however many years, when it's the result of a NULL last argument that's at issue in this converstaion?
Tom