Alexandre Benson Smith wrote:

> But when I was replying I saw he wants just the integer part besides
> rounding, then I will suggest an UDF.

There are different kinds of rounding, most of them having different way
to handle 0.5 values. For some uses this is enough:

select cast(x + 0.5 as integer) from rdb$database;


--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org