title: Update a table and return both the old and new values
body: <p>Im writing a VB app that is scrubbing some data inside a DB2 database.  In a few tables i want to update entire columns.  For example an account number column. I am changing all account numbers to start at 1, and increment as I go down the list.  Id like to be able to return both the old account number, and the new one so I can generate some kind of report I can reference so I dont lose the original values.  Im updating columns as so:</p>
  
  <pre><code>DECLARE @accntnum INT 
  SET @accntnum = 0 
  UPDATE accounts
  SET @accntnum = accntnum = @accntnum + 1
  GO 
  </code></pre>
  
  <p>Is there a way for me to return both the original accntnum and the new one in one table?</p>