On Thu, 21 Aug 2003 10:32:29 -0600, Francisco Roldan

<froldan5b.com.gt> wrote:

Well, not exactly, but this may do . . . . the trunc() frunction.>

>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 ?

>

e.g.

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

## Bookmarks