Hi Stephane,

For ODBC driver you can use escape sequention:

 * {d 'YYYY-MM-DD'}
 * {ts 'YYYY-MM-DD hh:mm:ss'}

 WHERE field={d '2004-01-30'}
 WHERE field={ts '2004-01-30 11:11:11'}

MartinJ

>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