>I've been writing some code that writes, compiles, and executes SQL statements. I've found in VFP 5.0 that the length of the WHERE clause is extremelly limited relative to the alleged capacities of the product. For example, a WHERE clause with only 5 or 6 "BETWEEN" clauses, or an IN (...) clause with a few dozen entries, will generate an "SQL expression too complex" error. Please note that we are talking about a command that in its entirety is only a few hundred characters long, far less than the published limit.
>
>My recommendation: If you are planning to use SQL with long WHERE clauses in your app (or have your app generate and execute them), use a different product than VFP.

I cannot imagine SQL query with 5-6 between for the case of right database design. By the way did you try to run long Where query for VB. You can start it and go to sleep.