hi,
how are you and thank you for reply,
you mean if my old table have fields as a,b,c,d

i can create new table have fields as t,a,b,v,c,y,d

and via append ...
use newtable
append from oldtable&& ican get all data as it is mean
t=0 or null
a=a
.
.
.

thanks.
>No, the new field will be added last. If you really need the fields in a special order, which I think is a bad idea, you must go via a temp file. Create a new table with the correct structure and the fields in the correct order, and append from the temp table.
>
>>hi ,
>>thank you for reply and help,
>>
>>is there away to add newfield to my table and put it as first field at my table vai alter
>>ALTER TABLE alldat ADD COLUMN num n(9) && as first field
>>
>>thanks.
>>
>>>>hi,
>>>>thank you for reply,
>>>>i think alter table good idea for me,
>>>>
>>>>to add new field i can do ..
>>>>ALTER TABLE Customer ADD COLUMN Fax c(20) NULL&&add from fvp help
>>>>ALTER TABLE Customer DROP COLUMN Fax2 &&drop from fvp help
>>>>
>>>>but
>>>>1.how i can change field name as under, from Area to state
>>>>ALTER TABLE alldat ALTER COLUMN area n(5)
>>>>2.how i can change field name and data type of filed
>>>
>>>I don't have VFP 9 installed right now.
>>>
>>>According to the help of version 6, it seems that you can not change the column name with ALTER TABLE. Perhaps there is a way in VFP 9 - I don't know.
>>>
>>>However, you can copy the information to a new column (field). Do the following (assuming you want to change from character to currency):
>>>
>>>

>>>alter table MyTable add column NewColumn Y
>>>update MyTable set NewColumn = val(OldColumn)
>>>alter table MyTable drop column OldColumn
>>>