what is the limitation in umber in the in clause
I had tried it once. It is 1000.
If you want the limitation for IN clause then it is also not good for query tuning you should use exists . Read Tips and Techniques by Richard Nimeic