Remove grant_nbr= from the beginning of this statement. HTH
>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
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.