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