Newbie question on SQL Server 2005 "+" string concatenation

[NewsBot]

I have a SELECT*query, in which something like below:-

 

(SerialNumber.Number + '- ' + SerialNumber.Description) AS SerialNumberInfo

 

When the SerialNumber.Number is a null value, the SerialNumberInfo will return null value even though SerialNumber.Description contain a value. Is there any solution to change the logic where either field has value will return value AS SerialNumberInfo? Thanks

 

 

More...

 

View All Our Microsoft Related Feeds