>Hi Naomi.
>
>>Did anyone find a maximum number of items you can use with select .. Item IN (...) clause?
>
>According to the help file (under System Limits, IIRC), it's 24.
>
>Doug
No, it's the INLIST limit. I've checked Help and I could not find anything specifying the limit explicitly. However, my colleage found it to be 159 and I also confirmed in a simple test.
If it's not broken, fix it until it is.
My Blog