I haven't tried that because the IN & the NOT IN work together without the COUNT so I assumed that the lists are ok. However, I will try building those conditions up and see what I get.
Thanks & regards, Alastair. ----- Original Message ----- From: "Mike Young" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 20, 2002 12:01 AM Subject: Re: Problem with select statement > Alastair, > > One more thought on this. Perhaps there is some kind of limit > on the number of items in the IN part (althought the documentation > does not state there is). Try taking some out and see if that makes > a difference. I don't see anything wrong with what you are doing > though it is just longer than others that I have constructed. > > Best regards, > Mike Young > > On Fri, 19 Apr 2002 23:24:54 +0100, Alastair Burr wrote: > > >Yes, Mike, they are integers and I've already tried quotes which, rather > >surprisingly, DIDN'T fail on syntax which I expected when comparing integer > >to text. > > > >Didn't give me what I wanted either!! > > > >Thanks & regards, Alastair. > > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
