You can do it with floor and ceiling udf functions





ibrahim bulut

software and database expert

iletisim online ltd.sti.

turkish republic

_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Balazs Zoltan
Sent: Wednesday, January 31, 2007 7:44 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] UDF to return fractional part of a number



Hi everyone,

Is there a way to get the fractional part of a number from an sql query?
Ex:
43,01 -> return 01
22,99 -> return 99

Because of a calculation in these cases I need to be able to round up or
down the value, but in any other
case retain the original value.

[Non-text portions of this message have been removed]



__________ NOD32 2025 (20070201) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com



[Non-text portions of this message have been removed]