I seem to recall that Calvin said that the limit was removed in an earlier version, and now depends on the amount of RAM. However, the error message "Statement is too long" is probably shown because the whole statement is too long???

>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.