How to do a mass field change

[brentbond]

I have used Family Phone 3 to contain some numeric information for our local needs. Because of an operations change in 2011, I would like to use the Database manager utility to make a mass change to that field. Basically "if Family Phone 3 = 150 then Family Phone 3 now = 200" ...... "If Family Phone 3 = 250 then Family Phone 3 now = 225". What syntax would I use to make these mass changes? Thanks for any insight you can give me.


----- Brent -----

[Zorak]

Make a backup before you start... there is no undo button in the Database Manager!

use ma (hit Enter or click Run Command)
replace all phone3 with "200" for phone3="150" (hit Enter or click Run Command)
replace all phone3 with "225" for phone3="250" (hit Enter or click Run Command)