Concat two column in a select statement sql server 2005

Question

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 ..

Answer 1

SELECT FirstName + ISNULL(' ' + SecondName, '') from Table