Limit to number of items in a List [WHERE id IN (,,,,)]

[Craig B.]

Does any know if there is a limitation on the number of items you can
contain within an SQL list. (e.g. WHERE id IN (,,,,) ). And if that
differs from having a sub-query oppose to literal values?

Regards,
Craig.

[Frank van Bortel]

Re: Limit to number of items in a List [WHERE id IN (,,,,)]

Craig B. wrote:

Does any know if there is a limitation on the number of items you can
contain within an SQL list. (e.g. WHERE id IN (,,,,) ). And if that
differs from having a sub-query oppose to literal values?
>
Regards,
Craig.

Yes. At a certain point a subquery will be
easier to write, maintain and code.
--

Regards,
Frank van Bortel

[charely]

Re: Limit to number of items in a List [WHERE id IN (,,,,)]

999

"Craig B." <craig.bender@p racticeone.coms chreef in bericht
news:6a45b902.0 403021214.68b7f f8c@posting.goo gle.com...

Does any know if there is a limitation on the number of items you can
contain within an SQL list. (e.g. WHERE id IN (,,,,) ). And if that
differs from having a sub-query oppose to literal values?
>
Regards,
Craig.