Re: Rounding numbers

Posted in 1993

informix users bb — Mon, 8 Feb 93 08:23:30 MST — source: Informix-list mailing list archive (1991-1998)

frank, try, select order_num, ROUND(total_price,2) from items where ROUND(total_price,2) = 125.25; this is almost straight out of the isql reference manual, pg. 7-374. ------------------------------------------------------------------------------ | . . Bob Baskett | ... ... Software Engineer, DBA | ..... ..... Business Systems Integration Group | .. ... .. Semiconductor Products Sector | . . . Mesa, AZ | | Motorola, Inc ------------------------------------------------------------------------------