Posted by Techhead on 06/04/07 19:33

I am running into an issue when adding data from multiple columns into
one alias:

P.ADDR1 + ' - ' + P.CITY + ',' + ' ' + P.STATE AS LOCATION

If one of the 3 values is blank, the value LOCATION becomes NULL. How
can I inlcude any of the 3 values without LOCATION becoming NULL?

Example, if ADDR1 and CITY have values but STATE is blank, I get a
NULL statement for LOCATION. I still want it to show ADDR1 and CITY
even if STATE is blank.

Thanks

• Next in forum: Re: Nulls in columns additions when 1 or more column values is blank
• Prev in forum: Copy Row Of Data From Table to Table In Same DB
• Thread view: Nulls in columns additions when 1 or more column values is blank

[Reply to this message]