Re: float to integer?

From Mieke Citroen: * * ----> How does one round a float number to an integer in Informix? * * That is, without pulling any fancy tricks or a do-it-yourself * routine, but plain and simple a *function* (or is that too much to ask?) It depends on how you want to round it, but if you want >= .5 to round up and < .5 to round down then do: LET integer_num = float_num + .5 Ex. Program MAIN DEFINE fltnum FLOAT(4), intnum INTEGER, rndnum INTEGER LET fltnum = 150.6678 LET intnum = fltnum LET rndnum = fltnum + .5 DISPLAY "Float ",fltnum DISPLAY "Integer ",intnum DISPLAY "Rounded ",rndnum LET fltnum = 150.3456 LET intnum = fltnum LET rndnum = fltnum + .5 DISPLAY "Float ",fltnum DISPLAY "Integer ",intnum DISPLAY "Rounded ",rndnum END MAIN Hope this answers your question, Robert Minter |Data Systems Support| \\\\\\_/// Programmer, Software Development | Orange, CA | ( _ _ ) internet: rob@dssmktg.com | Tel: 714.771.0454 | (| ^ |) bangpath: uunet.uu.net!dssmktg!rob| Fax: 714.771.3028 | \\`-'/ #include <disclaimer.h> \\_/