Retreiving part of decimal in SQL Select

[IanKidd]

I have a field that is a decimal - how do I use a SELECT SQL statement to retrieve only the amount before/after the decimal point?

i.e. value is 4.55 I want to select "4" and "55".

Thanks.

 

[olded]

Ian:

You can use one of the Informix built-in functions:

Given:

table o_table with a decimal column issqty:

select TRUNC(issqty), ((issqty - TRUNC(issqty)) * 100) from o_table

is close to what you want. There is a built-in MOD function, but I'm unable to get it to work.

This should get you started.

Regards,

Ed