>Why can't I use this statement?
>set filter to grant_nbr=substr(grant_nbr,1,1) ="N" .or. substr(grant_nbr,3,1) ="C" .or. substr(grant_nbr,3,1)="J" .or. substr(grant_nbr,3,1)="L"
>??????????????Thanks Rick
Hi Rick,
Assuming there is a typo in substr(grant_nbr,1,1) and it should be substr(grant_nbr,3,1) you can use this statement:
set filter to inlist(substr(grant_nbr,3,1),'N','C','J')
locate
I think you know, that filters significantly slow perfomance...
If it's not broken, fix it until it is.
My Blog