>Hello,
>
>I somehow got used to it, but it is nevertheless annoying: When doing a COUNT(*) in MySQL, mySQL creates a BigInt data type of the result. In the VFP view, the result is a character value. In order to do further calculations I have always to keep that in mind.
>
>Unless somebody has a trick to get the result as a numeric type in MySQL?
>
>I am using ODBC driver 5, same was with version 3.
Can to CAST() result of COUNT() to integer or decimal in the query?
--sb--