>Hi Erik and Ed,
>
>Today I made a quick test: I run the same SQL, using INLIST(town,'AVON,NEWT') and town IN ('AVON','NEWT'). INLIST() worked considerable faster! What is your experience here?
Is this a really old thread I got a copy of? I don't recall it lately :)
Anyway, INLIST() is optimizable, perhaps IN is not, at least not the way it's used here for a list of items.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.