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
>