>>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")

Thanks for the reply. Unfortunately I can't use your suggestion in practice because the "real" query is

SELECT DISTINCT < myFieldList including a BIT field >

Even more unfortunate is that the GROUP BY query still produces a character field.