sodakotahusker
Programmer
- Mar 15, 2001
- 601
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!!!
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!!!