>create table tempX (district c(3))
>
>select tempX
>index on district tag district
>insert into tempX (district) values ('1')
>insert into tempX (district) values ('1A')
>insert into tempX (district) values ('1B')
>insert into tempX (district) values ('1C')
>
>lcInlist = " inlist(alltrim(district), '1','1C')
>select * from tempx where &lcInlist into cursor junk
>
>_tally = 4 && all four records with 'SET EXACT ON' & 'SET NEAR OFF'
SET ANSI ON will give 2. SQL behaviour depends on this setting.
Edward Pikman
Independent Consultant