Hello,

From VFP8, I execute some SQL requests through ODBC.
The data sources can be SQL Server, DBF tables (odbc), MySQL, and so on...
A problem appears when I want to construct requests with dates.
According to the SQL system, the syntax for dates are different.
Ex.: ...where date='10-14-2004' works on SQL server but does not work with DBF tables.
Is there a 'universal' syntax which can work on all SQL systems ?
Any tips ?

Thanks for your help.
Regards,
Steph