Oracle Sort but not constrainted

Hi,

I am attempting to do a query of an airline database like:

Flight_Id	Number(5)
Airline		Varchar(2)
Depart_Date	Number(8)
Dapart_Time	Number(4)

select * from airline_flights where Depart_Date = 19990410;

But I need to sort the Airline Codes by a specified list which may be different each time I do a query. For example, I do the above query, but want codes 'NW' and 'UA' to be at the top of the table. Next query might need 'US' at the top.

Is this possible? If so, can someone head me in the right direction?

Thanks,
Steve K.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 09 1999 - 09:36:17 CDT