Re: is there limit on "in operator"?

I think it is 1,000 elements.
Jim
"Joe D" <cdu10_at_hotmail.com> wrote in message news:d775f0aa.0210101920.3ddd5905_at_posting.google.com...
> I have to use a select query using in operator where the in clause
> can not be a subquery since the conditions are not in the database.
> The query like:
> select * from mytable where mycolum in
> (very-long-concatenated-string-for-values);
>
> I am concerned that if there is limit on in, then if currently i do
> not run into trouble, sometime maybe.
>
> Can anyone help? Thanks
Received on Fri Oct 11 2002 - 05:34:27 CEST