Does anybody know what is the limit for the number of values one can
have in a list of expressions (to test for a match) for the IN clause?
For example,
SELECT au_lname, state
FROM authors
WHERE state IN ('CA', 'IN', 'MD')
Is there a limit in the number of expressions that can be included in
the list to check for a match to STATE? I know this is a bad example as
there are only 50 states, but my actual query is similar to this, the
only difference being I may have about 1000 values in the 'IN' clause
to test for a match.
TIA!