>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

What is the point of such strange select statement? The only possible values you can get are 1/0 or NULL. Are you checking if you have all 3 of them?

In other words, why do you need to go to MySQL at all to get this result?