<div>
I haven't found any limit in manual, so I believe, that it's big enough :-) However, if you reach the limit, you can always by-pass it by storing your choices into some table and then use &quot;select * from titles where title_id IN ( select choise from mychoices )&quot;
</div>


I haven't found any limit in manual, so I believe, that it's big enough :-) However, if you reach the limit, you can always by-pass it by storing your choices into some table and then use "select * from titles where title_id IN ( select choise from mychoices )"

<div>
I infact tend to believe there is an inherent sybase limit for a list of items that are explicitly listed out in the in clause, but not for nested SQL statements.<br />
<br />
The limit on 12.5 appears to be 439. Try it and let me know. <br />
<br />
I am postively certain that on older versions this limit used to be 200 items. So appears as if it has been increased.<br />
<br />
Thanks.<br />

</div>


I infact tend to believe there is an inherent sybase limit for a list of items that are explicitly listed out in the in clause, but not for nested SQL statements.

The limit on 12.5 appears to be 439. Try it and let me know.

I am postively certain that on older versions this limit used to be 200 items. So appears as if it has been increased.

Thanks.


<div>
I can advise from experience that under 12.5.x that a list id 30 id's may not use the index, whereas 10 then 10 then 10 will always use the appropriate index.
</div>


I can advise from experience that under 12.5.x that a list id 30 id's may not use the index, whereas 10 then 10 then 10 will always use the appropriate index.

<div>
<div class="content wysiwyg-content">
In a SQL select statement what is the limit for choices that i can give in a IN clause.For instance in the following example<br />
select * from titles where title_id IN ( a,b,c,d,.....How far can it go.) What is the limit.
</div>
</div>


In a SQL select statement what is the limit for choices that i can give in a IN clause.For instance in the following example
select * from titles where title_id IN ( a,b,c,d,.....How far can it go.) What is the limit.

Limit of selections in IN clause

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.