thank you very much, it works as under faster than select

SET FILTER TO  char4=CHRTRAN(char4, CHRTRAN(char4,'0123456789',""), "")

>Sorry, I misunderstood what you wanted.

>Select * from afm where CHRTRAN(char4, CHRTRAN(char4,'0123456789',""), "")=chr4

>
>>hi,
>>i try it via vfp9
>> no result.
>>
>>my field have data as ex..
>>TRL0670030 &&if found skip
>>065978963
>>LLP6665551 &&if found skip
>>065965455
>>ADSL0023718
>>065932103
>>
>>i need to see all data as
>>065978963
>>065965455
>>065932103
>>.
>>.
>>
>>thanks
>>
>>
>>
>>
>>>

>>>SET FILTER TO AT('065832103',CHAR4)>0

>>>or

>>>SET FILTER TO '065832103'$CHAR4

>>>or all in one line, if you don't need to change any data

>>>Select * from afm where '065832103'$CHAR4

>>>
>>>>hi all,
>>>>
>>>>i have field(char4) character type at my table have data as
>>>>
>>>>TRL0670030
>>>>LLP6665551
>>>>ADSL0023718
>>>>065932103
>>>>
>>>>i need to filter or select all records have only numbers as 065932103
>>>>
>>>>i try as under ,no result
>>>>

>>>>USE afm
>>>>SET FILTER TO char4=SUBSTR(char4,5,9)
>>>>brow
>>>>