General information
Forum:
Microsoft SQL Server
Title:
Incorrect syntax near '='
I encountered this error message when trying to update
a record in the SQL Server 6.5
Error message: Incorrect syntax near '='
My SQL statement is:
Update tablename SET qty = qty + 20 FROM tablename
where Rtrim(LTrim(Order_no)) = '12345' AND
RTrim(LTrim(sku_no)) = '11111'
Anything wrong with this statement? Pls help, thanks.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only