CREATE TABLE Temp10 (Order c(1)) INSERT INTO Temp10 (Order) VALUES ("A") INSERT INTO Temp10 (Order) VALUES ("A") INSERT INTO Temp10 (Order) VALUES ("A") UPDATE Temp10 SET Temp10.Order = "B" RETURNGenerates no errors for me. Probably best that you renamed the field, reserved words as field names are a pain in the long run.