I want to update a column by adding a constant to the current value of the column for multiple records. I tried:
UPDATE fuel_surcharges as X
SET surchargepercent =
(SELECT (surchargepercent + 6)
WHERE fuelsurchrecid = X.fuelsurcrecid)
I'm not sure I'm using the correct technique by trying to do this with a subquery. Any help would be greatly appreciated.