Thanx, i ll try your solution.

Anyway, how do i use the round udf, i read that firebird has a round udf,
but i couldnt find how to use it anywhere.

On 8/7/06, Adam <s3057043@...> wrote:
>
> --- In firebird-support@yahoogroups.com<firebird-support%40yahoogroups.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
>
>
>


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