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.