--- In firebird-support@yahoogroups.com, "betoban2007"
<betoban2007@...> wrote:

>
> I tried to use functions to round numbers (ROUND, FLOOR <, CEIL >) BUT
> Firebird NOT permitted it's.

Your question does not provide enough information for anyone to help
you. You do not even state which version of Firebird you are using.
What do you mean by NOT permitted? Do you get an error message?


SQL> select round(1.5) from rdb$database;

ROUND
=====================

2

SQL> select floor(1.5) from rdb$database;

FLOOR
=====================

1

SQL> select ceil(1.5) from rdb$database;

CEIL
=====================

2


Adam