Combine two column with sql statement

semomaniz

I was able to combine three columns with following sql statement but the problem that i am having is if one of the column has a null value the concatenation does not work and the sql statement does not return any thing. I am not sure why this is happening. Is there a way to accomplish this even though the fields contain null value.

Sql statement:

Data types:

Contactid -- int
FirstName -- nvarchar
LastName -- nvarchar

Note: The above sql statement works perfect if non of the fields have null value.

Thank you in advance

Sep 9 '08 #1

ck9663

Yes.

Use ISNULL() function.

Try this:

-- CK

Sep 9 '08 #2

semomaniz

It worked

Thank you

Sep 9 '08 #3