Re: I would like to know about IN operator,
Date: 20 Feb 2002 02:36:13 -0800
Message-ID: <cb748650.0202200236.7b895401_at_posting.google.com>
mngong_at_yahoo.com (michael ngong) wrote in message news:<ecf365d5.0202190913.52ce1ab8_at_posting.google.com>...
> sohelcsc_at_yahoo.com (Leader) wrote in message news:<b1a93c73.0202190606.7a18c234_at_posting.google.com>...
> > Hi All,
> > I have a problem for that i need to know Is there any maximum range
> > within IN operator? I mean inside IN how many values we can compare
> > (13, 14, 23,......)??
> >
> >
> > Tahnks
> > Hoque
>
>
> I have not come across an error in those lines though but when you
> have so many things to choose from how about not in rather than IN
>
> Hope that helps
> Michael Tubuo Ngong(Sr DBA)
You might have an IN list that is 1000 long in a table of 100M records.... Not In is Not Useful in that situation....
Regards Received on Wed Feb 20 2002 - 11:36:13 CET