VFP ODBC drive supports VFP6 query syntax only. It has not been updated since than. You've to use VFP OLE DB provider

>
>I tried you code on direct VFP tables. It worked fine. But when I used the same code via ODBC, it failed and gave me a syntax error.
>
>