RE: Sorting numeric data stored as char (numeric vs. lexical)

Posted in 1999

Tino Cremidis — Tue, 28 Sep 1999 08:30:32 -0400 — source: Informix-list mailing list archive (1991-1998)

> VP wrote: > > > > Sorting numeric data stored as char (numeric vs. lexical) > > > > I have numeric data stored in a char-column. > > The data is NOT zero-padded. > > > > The question is, how do I retrieve the data in > > sorted order (actually, I just want the LAST record) > > > > As you can imagine, the problem is that > > numerically, 100 > 99, but lexically 99 > 100 > > > > I have the option of zero-padding all the data You can try: Select YourColumn + 0 From YourTable order by 1 If *all* data is numeric, this should work HTH Tino