Re: cusotm sort in order by

Well,
You could add a field that would have an assending or decening value you could sort of so
Table T(A,B,C) where B could have your creatures and C could be their location in a sorted list 1,2,3....
or you could do some UNIONS and select each record in the order you want to display it with it's own select.

Henry

Nandakumar wrote in message <7o59ns$e20$1_at_nnrp1.deja.com>...
>I like to sort the rows of a table in a custom order of a column.
>Say the table T(A,B) has values for B as
>'Snake' 'Dog', 'Horse', 'Elephant'.
>I would want the select to list the values in the order
>'Dog' 'Hosrse' 'Snake' 'Elephant'. (** Not in ASC or DESC orders)
>
>Would appreciate any help.
>--
>Nandakumar
>Systems Analyst
>New York
>(N.Kumar_at_rocketmail.com)
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Mon Aug 02 1999 - 21:16:59 CDT