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

the limit is:

? SYS(3055)/2-2

Then the default is 158 and max it is 1018.