Re: how to sort according to wierd criteria?

From: Steve Haynes <steve_at_rwx777.demon.co.uk>
Date: 2000/07/13
Message-ID: <kkjpvJAaKjb5Ewz7_at_rwx777.demon.co.uk>#1/1


In article <8kklc4$gli$1_at_nnrp1.deja.com>, mitch23_at_hotmail.com writes
>I need to sort my Orders table based on Item_ID and then Order_ID. The
>problem is the sort for Item_ID is not alphabetic but is instead to be
>based on specific order requested by my users (JU0010, WF0010, CO0060,
>Z00870...).
>
order by decode('JU0010',1,'WF0010',2,'CO0060',3,'Z00870',4)...... asc or desc according to taste.
Steve Received on Thu Jul 13 2000 - 00:00:00 CEST

Original text of this message