Hi Rich,

What datatype is used in mysql table for field myBitField?
What datatype VFP use in first case?
What is version of MySQL ODBC driver?

BTW, Yes, in any case MySQL ODBC driver/VFP can covert any datatype to char/varchar.

MartinaJ

>Working with a MySql backend.........
>
>

=SQLEXEC(lnHandle, "SELECT myBitField FROM mySqlTable","myCursor)

>The results are logicals, as I expected.
>
>

=SQLEXEC(lnHandle,"SELECT DISTINCT myBifField FROM mySqlTable","myCursor")

>and the results are character
>
>Does anybody have an explanation for this? Even better, is there a simple way to get it back to the "correct" data type?
>
>Thanks to all........Rich