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
>>