Stupid SQL question

Hello,
I have the following query:
select city || '-NE' from blah where city = 'OMAHA' and state = 'NEBRASKA'
that works the way I want it to. My problem is that I want to include an additional statement like
select city || '-IA' from blah where city = 'OMAHA' and state = 'IOWA' so that my end result is OMAHA-NE when the state is equal to Nebraska and OMAHA-IA when the state is equal to Iowa. Any ideas on how to do this?

Thanks,
Marcy Received on Thu May 28 1998 - 13:04:01 CDT