Joe

>Does FB 1.0 have a rounding function?
>
>I want to issue a command that sets a particular field as the value of
>another field, multiplied by 2.3, but I want the result rounded to 2
>decimal places.
>
>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) )

Kubanychbek