Re: [GENERAL] ORDER BY 'DK', 'DE', DESC?

2004-05-21 Thread Adam Ruth
On May 20, 2004, at 12:19 PM, Stephan Szabo wrote: On Thu, 20 May 2004, Adam Ruth wrote: On May 20, 2004, at 11:20 AM, Stephan Szabo wrote: On Tue, 11 May 2004, [ISO-8859-1] Victor Spng Arthursson wrote: Hi! I would like to know if it's possible to give a priority order of how to sort the

[GENERAL] ORDER BY 'DK', 'DE', DESC?

2004-05-20 Thread Victor SpÄng Arthursson
Hi! I would like to know if it's possible to give a priority order of how to sort the returning rows? Like for example to order every row with a field language = DK first, then the rows with field language = *DE' and last the other languages, ordered alphabetically? Sincerely Victor