The syntax for IN conditions is as follows:
{ expression [ NOT ] IN ( subquery )
| expression [ NOT ] IN ( expression )
| expression [ NOT ] IN (value-expr1 , value-expr2
[, value-expr3 ]... ) }
Without the NOT keyword, the IN condition is TRUE if expression equals any of the listed values, UNKNOWN if expression is the NULL value, and FALSE otherwise. The NOT keyword reverses the meaning of the condition but leaves UNKNOWN unchanged.
The maximum number of values allowed in an IN condition list is 250,000.
IN conditions are compatible between Adaptive Server Enterprise and Sybase IQ.
