Hi, Gerald,

Some time ago, I asked a question not unlike that. Check out Thread #686643, and within that thread, Message #686680. That may give you some ideas. (My question was Oracle and SQL Server, whereas yours is the VFP provider and the SQL Server provider).

Keep in mind that the query engines for SQL Server and VFP are not identical. For more detailed/complicated queries (subqueries, embedded CASE statements vs IIF, etc.) the query syntax will be different across databases.

Depending on your requirements, it may be difficult for your query engine to produce a SQL SELECT statement that can run against multiple back-ends. (Unless your query 'builder' takes into account the differences, or unless you're writing stored procedures in the database).

Hope this helps...

Kevin