Re: Limit to number of items in a List [WHERE id IN (,,,,)]
From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 02 Mar 2004 21:28:47 +0100
Message-ID: <c22qmq$dkm$1_at_news4.tilbu1.nb.home.nl>
Date: Tue, 02 Mar 2004 21:28:47 +0100
Message-ID: <c22qmq$dkm$1_at_news4.tilbu1.nb.home.nl>
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 BortelReceived on Tue Mar 02 2004 - 21:28:47 CET