Calling three column in to one column in the grid

Question

i tried with plus mark its working ,

but if there is any null value in the database column its shows null for other two values

ex: BankName+SuplierName+Customer AS CusDetail 

If BankName= BOC , SuplierName = NULL & Customer= NULL

all the columns are showing null

like thsis

CusDetail

------------

Null

Null

Null

i there any solution for this???

Answer 1

Use COALESCE to eliminate NULLs

SELECT COALESCE(BankName,'unknown')+COALESCE(SuplierName,'unknown')+COALESCE(Customer,,'unknown')

FROM tbl

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/