Maximum number of items for query using the IN operator

Maximum number of items for query using the IN operator

Post by David Tucke » Thu, 18 Oct 2001 06:23:39



What is the maximum number of items in a list when using the  IN operator.
Such as:

Select * from customers where name IN ('David', 'Steve',...)

Thanks,
David

 
 
 

Maximum number of items for query using the IN operator

Post by Aaron Bertrand [MVP » Thu, 18 Oct 2001 07:11:30


I don't believe there is a limit to the number of elements, but there is a
limit to the oversall size of the command - 64kb.

www.aspfaq.com


Quote:> What is the maximum number of items in a list when using the  IN operator.
> Such as:

> Select * from customers where name IN ('David', 'Steve',...)

> Thanks,
> David