Joe

>>update mytable
>>set field1=cast(field1 as numeric (18,2) )
>>
>>
>
>Will that work if the target field is a float?
>

Try.
I used cast to round double precision.

Kubanych.