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

On Thu, 21 Aug 2003 10:32:29 -0600, Francisco Roldan
<froldan@5b.com.gt> 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 ?
>

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

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

I haven't tried it but

select *
from table
where decimal_col != decimal_col::INT

should work

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

--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #