>Sergey
>
>>The INLIST() function is limited to 25 items in the list. You should reconsider your design also because the filter expression is not optimizable. The bigger table will get, the slower your code will became.
>
>INLIST is indeed optimizable
>
>if there is an index on UPPER(PARTNUM), SELECT * FROM PARTS WHERE INLIST(UPPER(PARTNUM),"1","2","3") will report full optimzation.
>
>The empty(sent) part is not optimizable.
Hi Mike,
Yes, you're correct.
--sb--