>>I coded a program in vfp50. Now, after the program was distributed,
>>The customer wants me to change one of the fields in one of the tables. The field he wants to change is:
>>Num decimal
>>3 2
>>
>>to this
>>Num decimal
>>3 3
>>
>>The customer does not wants to loose any data and he wants to be able
>>to transfer data from the old number fld to the new one.
>>I have to do this using program code....Any ideas?
>
>Alter table mytable alter column myfield N(3,3)

... see VFP Help on ALTER TABLE - SQL for all the details.