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