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

In MySQL Cast can be one of the following types:
Binary
Char
Date
Datetime
Decimal
Signed integer
Time
Unsigned integer

I have tried it before, but if I use signed or unsigned integer, it creates a character result. But now that you mention it I checked and using Decimal does result in a numeric output. I never thought of using Decimal, have to check what they mean with that. Strangely enough, it always displays two decimal points, but for my calculations that will work.