title: Foxpro SQL Query for > 24 Criteria
body: <p>I'm using OleDB to connect to a FoxPro DBF database.   I need to query a table for all items with column = key1 or key2 or key3...... key2000.  </p>
  
  <p>FoxPro apparently doesn't like long queries....</p>
  
  <p>I've tried both:</p>
  
  <pre><code>where (col like "key1") or (col like "key2") or ..... (col like "key2000")
  </code></pre>
  
  <p>and </p>
  
  <pre><code>where col in ("key1", "key2", "key3", "key4".... "key2000")
  </code></pre>
  
  <p>The first solution fails for "query too complex".  The second key fails for too many elements in the in range (apparently the max is 24).  This seems absurd...</p>
  
  <p>Is there a way for me to construct my query without multiple reads?</p>
  
  <p>Thanks. </p>