If I have a query
UPDATE tablename SET c1 = 10 - c2, c2 = 4 where ...
will the two assignments be evaluated from left to right?
Thanks in advance.
Anuradha