Posted by Seribus Dragon on 06/04/07 19:53

ISNULL(P.CITY,'')
Techhead wrote:
> 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
>

[Back to original message]