limits to select/where/in statement??
From: Doug <kark_1999_at_yahoo.com>
Date: Wed, 05 Dec 2001 16:57:01 GMT
Message-ID: <xlsP7.1714$5W5.842404_at_typhoon.ne.mediaone.net>
Date: Wed, 05 Dec 2001 16:57:01 GMT
Message-ID: <xlsP7.1714$5W5.842404_at_typhoon.ne.mediaone.net>
Does anybody know if there is a limit to the number of "in" values you can
have?
what if I have 500 values within the parens? would this be a problem?
thanks.
For example,
delete from customers where cust_no in (5343,2356,23467,23,664);