>Hi All:
>
>Is there a function out there that will always ROUND up if the following digit is greater than 0?
>
>Examples:
>
>
>ROUND(123.4512,2) returns 123.45
>ROUNDUP(123.4512,2) returns 123.46
>
>
>Kinda like CEILING, which only works on the integer level.
>
>Thanks,
>
>Yossi
How about something like
FUNCTION roundup(tnNumber,tnDigits)
RETURN CEILING(tnNumber*10^tnDigits)/(10^tnDigits)