• the value of the price field is:

    .05

    .25

    .6

    1

    1.25

    150.7

    250

    265.75

    etc

    so if there are no items price that are greater than $1000 then i would use the following: ?

    update field set price = price * cast(1.1 as numeric(1000,7))