>>While you have your answer, the real problem is that SQL Server 2000 always uses ANSI settings for things like datetimes. So
csql = "select * from prestacoes where data_venc <= '2/28/2006 00:00:00'"
should also work. The time portion of the above is optional.
>
>Now you're getting me confused. Isn't ANSI the yyyy-mm-dd date, and American date mm-dd-yyyy? That's when you get in VFP when you Set Date ANSI/American.
Geez, Dragan, I don't know. And I can't find where I read that. All I can say is that I don't have any problems with any of our SQL Servers when I use "mm/dd/yyyy" or add the time to it.
George
Ubi caritas et amor, deus ibi est