On Sun, Feb 01, 2004 at 06:22:30PM +0100, Tomasz Myrta wrote: > Dnia 2004-02-01 14:34, Użytkownik Michael Fuhr napisał: > > SELECT * > > FROM records > > ORDER BY lastName, > > firstName, > > SUBSTRING(term FROM 1 FOR 4), > > CASE SUBSTRING(term FROM 5) > > WHEN 'S' THEN 1 > > WHEN 'X' THEN 2 > > ELSE 3 > > END; > > or the easier one: > > order by lastname,firstname, translate(term,'SXF','123');
Blast...I just *knew* I was missing an easy, obvious solution. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
