>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.