Enviroment VFP 7, existing tables on a Novel server, new tables on a local PC running Win2k.

I have several tables which have an addition field. The new tables have test data in them. The new field is 1 character and has values A and B. I need to do the following:

1. remove existing test data
2. copy existing data and set new field to A
3. copy existing data and set new field to B and set 3 numeric fields to zero

What is the safest way to the do the above?