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