[prev in list] [next in list] [prev in thread] [next in thread] 

List:       dbi-dev
Subject:    Re: User-defined order
From:       "Martin Krgeloh" <mkr () dm-server ! cv ! com>
Date:       1998-01-29 9:15:21
[Download RAW message or body]

*** From dbi-users -- To unsubscribe, see the end of this message. ***

This is a multi-part message in MIME format.

Christopher,

you can also use DECODE to sort as you want. NOTE that the last field
contains the value to use if no other string matches.

select xx from tt order by decode(xx,'DESIGN',1,'CODE',2,'TEST',3,99);

Martin Kraegeloh
["vcard.vcf" (text/x-vcard)]
------------------------------------------------------------------------------
To unsubscribe from this list, please visit http://www.fugue.com/dbi
If you are without web access, or if you are having trouble with the web page,
please send mail to dbi-request@fugue.com.   Please try to use the web
page first - it will take a long time for your request to be processed by hand.
------------------------------------------------------------------------------


[prev in list] [next in list] [prev in thread] [next in thread]