>can somebody point me to resources outlining the difference on SQL capability between native VFP and VFP ODBC ?
>i have problems sending SQL statements that work in VFP.exe but not in ODBC

VFP ODBC driver was last time updated in VFP6 so it should be compatible with VFP6. Can you post your select statement and tell what exactly doesn't work in ODBC?