Re: [GENERAL] Ordering by a complex field

2007-07-21 Thread Patrick TJ McPhee
In article <[EMAIL PROTECTED]>, Robert James <[EMAIL PROTECTED]> wrote: % I'd like to order so that records where field='2' come first, then '1', then % '9', then anything but '0', then '0'. Is there anyway to do this in a % standard order by clause (that is, without writing a new SQL function)?

Re: [GENERAL] Ordering by a complex field

2007-07-18 Thread Michael Glaesemann
On Jul 18, 2007, at 20:12 , Robert James wrote: I'd like to order so that records where field='2' come first, then '1', then '9', then anything but '0', then '0'. Is there anyway to do this in a standard order by clause (that is, without writing a new SQL function)? # create table whatev