I am concatenating 2 fields in a st 1

[sodakotahusker]

I am concatenating 2 fields in a stored procedure - for example

city + " " + state as citystate

if city is null - citystate comes back null even if state has a value. Is there an easy solution to this so I don't have to resort to the CASE block???

Thanks!!!

 

[Andel]

Try this...

SELECT LTRIM(ISNULL(firstnm,'') + ' ' + ISNULL(lastnm,'')) AS CITYSTATE
FROM mytable


LTRIM is used so that it will not give you a blank space when there's no city. ISNUll is used to check for null values and replace it with 0 space.

Andel
andelbarroga@hotmail.com

http://andyb.8m.com

 

[Andel]

sorry, the example should be...

SELECT LTRIM(ISNULL(city,'') + ' ' + ISNULL(state,'')) AS CITYSTATE
FROM mytable


Andel
andelbarroga@hotmail.com

http://andyb.8m.com

 

[sodakotahusker]

Andel,
Works like a champ!!!!!!!!!!!! Thank you very much!!!!
Don