>

>
>lcSql = "SELECT substring(myField,1,3) AS myField,  COUNT(*) AS totItems " +;
>           "   FROM myTable"+;
>           "  GROUP BY substr(myField,1,3)"
>
>=SQLEXEC(lnConHandle,lcSql,"myCursor")
>
>? TYPE('myCursor.totItems') -----> "C"

>
>Does anybody know why this happens and if there are any other aggregate functions which return an ummmmmmmmm "unexpected" data type?
>
>FWIW - I got a numeric value by substituting SUM(1) for COUNT(*) but I'm still curious about this.
>
>Thanks to all........Rich

See also Annoying result from MySQL COUNT(*) Thread #1386273