>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
Grnat_Nbr is (I'm assuming) a character string. It will never be equal to .T. or .F. which is what the first expression is trying to evaluate it against. Try:
set filter to substr(grant_nbr,1,1) ="N" .or. substr(grant_nbr,3,1)$"CJL"
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao