>>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.
Thanks Ed, sure enough - somehow I had it unchecked.
Robert
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only