> >So, it would be something like:
> >
> >update mytable set field1 = ROUND(field2 * 2.3,2)
> >
> >Does such a function exist in FB 1.0, and if so, what is the exact syntax?
> >
> >
>update mytable
>set field1=cast(field1 as numeric (18,2) )

Will that work if the target field is a float?

-Joe