Re: Query for decimal part

Hi, Try something like this - select * from rep_data where (round(adr_cr_limit,0) * 100 - adr_cr_limit * 100) != 0 ( 100 because my col is decimal 2 ) Rgds Preetinder Francisco Roldan wrote: >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