>Just a follow-up question.
>Why does the field DATE (in the SQL Select you suggested) is a Char type? Nothing wrong. I would just like to understand why when you CAST the DateTime to DATE, the result is a char type and not a Date type.
>

Dmitry, adding to what was already stated in this thread, attached goes a more comprehensive VFP/ODBC/MSSQL compatibility chart.

I can't remember if I already posted it here. It will serve as a refresh, if that's the case.