Basic concept (with default settings)
select null + abc => null
anything added/concatenated to null is null.
and see this too http://technet.microsoft.com/en-us/library/ms176056(v=sql.105).aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
See the SQLServerCentral article Best Practice : coalesce vs. isnull? before you make a choice on which one to use!
Thanks. It worked.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply