Returning one of two possible values

Junketfunk · #1 (**permalink**) 10-13-03, 02:47

Hi guys,

I'm another newbie here.

I'm currently designing a small Access db that contains contact details:

Name
ResidentialSuburb
PostalSuburb

I need to create an SQL query that will return Name & "Suburb".
"Suburb" will contain ResidentialSuburb by default, but if this is empty, I would like it to contain PostalSuburb.

Is this possible? Im a bit stumped.

Thanks

r937 · #2 (**permalink**) 10-13-03, 05:51

Code:

select Name
     , iif(isnull(ResidentialSuburb),
         , PostalSuburb
         , iif(ResidentialSuburb=''
            , PostalSuburb
            , ResidentialSuburb)) as Suburb
  from ...

rudy
http://r937.com/

Junketfunk · #3 (**permalink**) 10-13-03, 09:02

Thanks Rudy,

Had a bit of a play around and it works a treat

Cheers
Matt

Internet Services

Web Development

Digital Marketing

Consumer Tech