Re: Query for decimal part

Hi Paco: Try with select * from shclog where (amount - amount::int) > 0 HTH ----- Original Message ----- From: "Francisco Roldan" <froldan@5b.com.gt> To: <informix-list@iiug.org> Sent: Thursday, August 21, 2003 11:32 AM Subject: Query for decimal part > Hi Everybody, > I got a table with a column named amount > of type decimal(26,8) . > I need to make a query to select the rows > with no-integers values on this column (amount). > I mean the rows with decimal part on its value. > > Something like this : > > select * from shclog > where get_decimals(amount) <> 0> > Assuming that the function get_decimals return the > decimal part of the column amount. > > Does exist a function like this ? > > Thanks in advance > sending to informix-list sending to informix-list