Concatenating a null value to a string

[PreacherUK]

Hi all,
I have a table containing a number of fields. Two of those fields contain strings I need to concatenate to display the whole name of an item. Occasionally one of the fields is NULL, which is a failing of the data scource, so theres not much I can do from that end.

This seems to be resulting in null being returned when one of the fields is null, rather than the name from the other field+null.

is there a way of treating this?

 

[JohnDTampaBay]

Check out the ISNULL function in BOL. It will substitute a value when NULL is encountered. Somthing like this:

SELECT FirstName + IsNull(MI, '') + LastName
FROM Customers

Also check out COALESCE and their cousin, NULLIF. Good luck!

--Angel
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[PreacherUK]

Excellent, thanks for that, I'll read them up