>>>>> "Bret" == Bret Stern <bret_stern@xxxxxxxxxxxxxxxxxxxxx> 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)
