--- In firebird-support@yahoogroups.com, "Fabio Gomes" <fabioxgn@...>
wrote:

>
> Hi all,
>
> Is there a way to round values in a stored procedure? i have to make
> some calculations to update some tables.. and i would like to round
> the values to 2 or 4 decimals.
>
> How can i do it?
>

With a UDF

or Multiply it by 100, cast as integer, then divide it by 100.0 should
work in straight PSQL.

Adam