>Hi everybody,
>
>Did anyone find a maximum number of items you can use with select .. Item IN (...) clause?
>
>The limit seems to be 159 items before it gives SQL: Statement too long (Error 1812).
>
>Thanks in advance.

In VFP 8 and earlier, 26. In VFP 9, it's based on SYS(3055).

But as Mike said, put the items in a cursor and don't worry about it.

Tamar