Originally Posted by
CeeBee
Easiest I can think of:
****Backup db****
Update the table, add new column [tmp] of type numeric double, default value NULL (you will be using this as a "failed to update" indicator)
Run query to update
UPDATE Table1 SET Table1.tmp = [your_money_field];
Validate all data was updated
SELECT * FROM Table1 WHERE tmp IS NULL
Drop old column, rename tmp to that name