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;-)