[V4RB] Updating fields with value from itself

[Christer Olsson]

Should I be able to update a field in a table with a calculated value with something like:

UPDATE myTable SET myFld = (myFld - 10) WHERE myFld2 = 'x' 

I want the field "MyFld" to be 10 less than it was before the Update.
-- 

  *************************************************************
  Christer Olsson   PO Box 9160        Phone +46 40 25 85 85
  Ljusa Idéer AB    SE-200 39 Malmo    Fax +46 40 25 85 89
  Kantyxegatan 5    Sweden             http://www.ljusaideer.se