Thanks Milan I'll give it a try.



Thomas.



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Milan Babuskov
Sent: Wednesday, November 21, 2007 10:46 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Bankers Rounding



Thomas Clarke wrote:

> (http://www.cis.

<http://www.cis.udel.edu/~breech/contest/problems/bankers-rounding.html>
udel.edu/~breech/contest/problems/bankers-rounding.html).

> Does anyone know of a UDF or a technique that can provide this type of
> rounding in Firebird?

There's F_ROUNDTOEVEN function in FreeAdhocUDF library:

http://udf.adhoc-
<http://udf.adhoc-data.de/documentation_english/dok_eng_math.html>
data.de/documentation_english/dok_eng_math.html

It seems to go exactly what you want.

--
Milan Babuskov
http://www.guacosof <http://www.guacosoft.com> t.com





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