Dealing with NULLs in Select

[Azita79]

Hi All,

In my tblInstaller I have 3 fields that I wana return as one
string. But when any of 3 is NULL the whole string retruns NULL

SELECT (InstallerName + ' , ' + Dba + ' , ' + BusName) as 'Name'
From tblInstaller

Any help would be greatly appreciated

Azita

 

[sunila7]

hi,

try this

SELECT (Isnull(InstallerName,'') + ' , ' + isnull(Dba,'') + ' , ' + isnull(BusName,'')) as 'Name'
From tblInstaller


Sunil

 

[Azita79]

Thank you so much Sunil

It worked great !