| Subject | UDF to return fractional part of a number |
|---|---|
| Author | Balazs Zoltan |
| Post date | 2007-02-01T04:29:02Z |
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]
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]