On Thu, 21 Aug 2003 10:32:29 -0600, Francisco Roldan
Well, not exactly, but this may do . . . . the trunc() frunction.>
>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 ?
select * from shclog
where (amount-trunc(amount)) = 0
amount is 57.95
trunc(amount) would be 57
difference would be 0.25
amount is 34.00
trunc(amount would be 34
difference would be 0