Concat two column in a select statement sql server 2005
concatenation, select, sql-server-2005
Solution
`SELECT FirstName + ISNULL(' ' + SecondName, '') from Table`
Problem
How to Concat two column in a select statement sql server 2005? Here is my statement `Select FirstName,secondName from Table`... Now i did try concating `secondName` with `FirstName` by using ``` Select FirstName + ' ' + secondName from Table ``` But some values are `NULL` in secondName column for some records.. My select statement returns `NULL` instead of `FirstName`.. I want to have `FirstName` if secondName is `NULL` ..