>

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

When I saw Sergey's response about BIGINT I looked at CAST(). My results mirrored Christian's (would have saved a little time if I had read his thread first < g >).

I can live with extra decimal digits.

Many thanks to both of you.

........Rich