MVSFORUMS.com

Catherine

I have a particular coloumn in my table named "STATUS" . This is a numeric field with values ranging as 10,20,30,40,50.

I donot want this coloumn either in ascending or descending order.
I want it in the following order ( 30, 10, 50, 20, 40). How shall i specify it in my order by clause?

dbzTHEdinosauer · Posted: Sat Nov 25, 2006 6:53 am Post subject:

you can use a CASE to set another selected column/:Host-variable based on your STATUS and ORDER BY the CASEd column.

or

using case, change the status from 30 to 'A 30', 10 to 'B 10' etc...
_________________
Dick Brenholtz
American living in Varel, Germany

Catherine · Posted: Sat Nov 25, 2006 7:02 am Post subject:

Dick,

thks a lot dick!! Could You Plz post the exact Case syntax i should give in the order by clause . I get an error while executing the query

kolusu · Posted: Sat Nov 25, 2006 8:51 am Post subject:

Catherine,

Try this untested sql

Catherine · Posted: Tue Nov 28, 2006 5:43 am Post subject:

Thks Kolusu.. I got it!!!