Re: Self defined sort order in SELECT

Michel Cadot wrote:
> "Tibor Jager" <tibor_at_despammed.com> a écrit dans le message de
>> is there any possibility to sort the result of a select-statement by self >> defined rules, before the result is passed to the application?

> If you have only 3 emp_status with the order you show, you can do:
> order by client, decode(emp_status,'Member of
Board',1,'Employee',2,'Secratary',3)

Yes, that's what I was looking for.
In Germany we have a saying that could be translated like this: Cant't see the forest, because there are too many trees... Sometimes it's just too easy ;-)

Thank you! Received on Fri Sep 10 2004 - 18:57:25 CDT