Thanks!
>>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)