Re: numeric sort on character field

Posted in 1999

Victor Kirilloff — Tue, 12 Oct 1999 09:28:34 +0400 — source: Informix-list mailing list archive (1991-1998)

Try SELECT chr+0 FROM tab ORDER BY 1 -----Original Message----- From: Kevin_Burdish@timeinc.com <Kevin_Burdish@timeinc.com> To: informix-list@iiug.org <informix-list@iiug.org> Date: 11 ''''''' 1999 '. 13:43 Subject: numeric sort on character field > > greetings and salutaions! > This question came up the other day and I couldn't find an answer > (other than a sort -n) How do I get a character field to sort > numerically? > Thanks, > Kevin > > >