subject:"Max use of 'in'"

Re: Max use of 'in'

2001-12-17 Thread Sinisa Milivojevic

Michael T. Babcock writes: > Is there an upper bound on how many items may be listed in an 'IN' clause? > > SELECT a,b,c from d where a in (1,2,3,4,5,6 ... 1123,1124); ...?? > > Thanks > -- > Michael T. Babcock > CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc)

Max use of 'in'

2001-12-16 Thread Michael T. Babcock

Is there an upper bound on how many items may be listed in an 'IN' clause? SELECT a,b,c from d where a in (1,2,3,4,5,6 ... 1123,1124); ...?? Thanks -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ -