Re: Can ACE select a CHAR field and treat it as an INTEGER?

Posted in 1994

Mike Aubury — Tue, 19 Jul 1994 16:27:20 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <thompsonCsw0v9.L2s@netcom.com> thompson@netcom.com "Eric Thompson" writes: > I have a situation in which I'd like to select a character field > from a table and sort it as though it were an integer. I know in advance > that all rows returned will have numeric values, even though the field > must remain a char field. Try select col_name+0 from ... -- Mike Aubury No Guarantee - No Charge :->