--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@s...> wrote:

> > I have a table (FB 1.5) with a field defined as Numeric(12,4). I use
> > this field in a store procedure with a variable defined as
> > Numeric(12,2). When the field is selected into the variable it stores
> > something like 123.4567 in the defined variable instead of rounding it
> > to 123.46 as expected. Is there a way to make Firebird respect the
> > variable definition in the stored procedure and round the number
> > correctly?
>
> Yes, use Dialect 3.

I am using Dialect 3.