thank you for reply,

i mean something as vfp code(program),if it is possible

as example
use mytable
locate for field name  begin with q
scan
convert(alter) character type  to numaric type
endscan

thanks again.
>>hi all,
>>
>>after import an excel sheet to vfp.dbf,
>>i have many fileds begin with q as q1,q2,q1a...etc.. all fields is characters type , i need to change all fields begin with q to numaric type .
>>
>>thanks for help.
>
>Look up the command Alter Table in help.