select cast(6.236 as numeric(18,2)) from rdb$database

seems to do it

----- Original Message -----
From: "Paco Ruiz" <gruposfcoruiz@...>
To: <firebird-support@yahoogroups.com>
Sent: Saturday, July 31, 2004 11:53 AM
Subject: [firebird-support] Round numeric


> Hi
>
> How can i round a NUMERIC(18,6), say two digital decimals?
> Do i need a extern library?
>
> Saludos
> Paco
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>