Wont display a null value 1

[saintedmunds]

HI

I have 3 columns Title Forename Surname
In my SP I have Title + ' ' + Forename + ' ' + Surname

This works great if there is a value in each field but if say i only Title and Surname it does not diplay anything.

How can i get around this?

Cheers

 

[ptheriault]

Use isnull

SELECT ISNULL(Title,'') + ' ' + ISNULL(Forename,"") + ' ' + ISNULL(Surname,'')



- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[LNBruno]

Try using COALESCE...

< M!ke >

 

[saintedmunds]

Simple

Thank you