=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
=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.