Thanks, Just the answer I was looking for.
Ted -----Original Message----- From: David M. Blocker [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2003 3:00 PM To: [EMAIL PROTECTED] Subject: [RBASE-L] - Re: SQL code Select ... IN (#list) There is no limit. If the column you're referencing is indexed, you won't hurt speed with more values. David Blocker ----- Original Message ----- From: "Ted Wolfley" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Monday, September 08, 2003 2:48 PM Subject: [RBASE-L] - SQL code Select ... IN (#list) > Hi, > > In the SQL select code, I am using the IN syntax to retrieve each > row's key field that matches the list of key fields retrieved from > another table. > It works with 5 key fields in the list and I am wondering if there is > a limit on the number of values that can be in the list? Or if there > is performance hit the number goes up? > > Ted > >
