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 > >
