>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

try

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