Charles Baldo
asked on
Display literal if field exists
Hi
I have a sql statement
select HouseNumber, Street, apartment, HouseNumber+' '+Street=' '+apartment as FullAddress from streetable
I want to be able to display the word ' Apartment ' in they have an apartment else just display the housenumer and street
thanks chuck
I have a sql statement
select HouseNumber, Street, apartment, HouseNumber+' '+Street=' '+apartment as FullAddress from streetable
I want to be able to display the word ' Apartment ' in they have an apartment else just display the housenumer and street
thanks chuck
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER