Subject Re: Firebird ROUND
Author Adam
You can create your own version of the round function using a UDF. I
am not sure / I could not find whether firebird already has this
function you are talking about.

If you are using Delphi, the main gotcha in creating your own round
function is that Delphi uses bankers rounding by default, where *.5
is rounded to the closest even number, not upwards as most people are
used to. You may want to use this function

function RoundCorrect(R: Real): LongInt;
Result:= Trunc(R); // extract the integer part
if Frac(R) >= 0.5 then // if fractional part >= 0.5 then...
Result:= Result + 1; // ...add 1

your function would look something like this

function MyRound(Value : Double; Prec : Integer) : Double;
if Prec < 0 then Prec := 0;

Result := RoundCorrect(Power(10, Prec) * Value) / Power(10,

--- In, "Sebastian J."
<jsebastianb00@y...> wrote:
> Hi to everyone, I have a question... I need to round a decimal
number as I used to do in SQL Server for example:
> Select Round(6.3254, 2) as Value_Rounded From MyTable
> The result looks like this:
> -------
> 6.3300
> How can I do this in FB, I was using the FB_UDF but the ROUND
Function only acept 1 parameter and I can't pass the decimals number
that I wanna.
> Thanks a lot.....
> Regards, Antonio
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail - You care about security. So do we.
> [Non-text portions of this message have been removed]