>>>>> "Bret" == Bret Stern <bret_stern@machinemanagement.com> writes:
Bret> My statement below updates the pricing no problem, but I want it
Bret> to be formatted with 2 dec points eg (43.23).
UPDATE ...
SET suggested_retail_price = round(suggested_retail_price*1.13, 2)
WHERE ...
assuming suggested_retail_price is already of type "numeric".
You could also have given the columm a type of numeric(18,2) or similar,
which would round all assigned values to 2 places.
--
Andrew (irc:RhodiumToad)
