Bruce,
>>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 :)
Actually, you somehow participated in this thread, so, I sent copy to you too, for a good company :)
>Anyway, INLIST() is optimizable, perhaps IN is not, at least not the way it's used here for a list of items.
It contradicts with Ed Rauh said in his message, so I checked and found, that INLIST works faster. BTW, I know, that $ is not optimizable function. What about AT()? If they are both non-optimizable, I'd rather change my code to use $ instead of AT(), as I do now, for shortness of sql string.
If it's not broken, fix it until it is.
My Blog