Hi Matt.

>Revised FixSql() method to handle that. Seems to work fine:

One other issue: hard-coded dates are specified differently in ODBC than VFP: {d 'YYYY-MM-DD'} vs. {^YYYY-MM-DD}. Rather than trying to parse a SQL statement for dates and converting the format, I suggest using a parameterized statement, such as SELECT Whatever FROM SomeTable WHERE SomeDateField = ?MyDateParameter. That statement will work against both VFP and an ODBC database.

Doug