>>Hi Experts,
>>
>>Why does the SQL Statement below yield a Character field for TOTALQTY?
>>
>>

>>SELECT A.DATE, F.DESCRIPTOR AS CUSTNAME, E.DESCRIPTOR AS PRODNAME, D.DATE AS PICKUPDATE,
>>       COUNT(*) AS TOTALQTY
>> FROM XOUT_HO A, XOUT_HODTL B, PARCEL C, JOBORDER D, PRODUCT E, CUSTOMER F
>> WHERE A.ID=B.XOUT_HOID AND B.PARCELID=C.ID AND C.JOBORDERID=D.ID AND D.PRODUCTID=E.ID AND
>>       D.CUSTOMERID=F.ID AND A.DATE BETWEEN "2010-01-01" AND "2010-10-15" AND YEAR( A.POSTDATE ) > 0
>> GROUP BY 1,2,3,4
>>

>>
>>Thanks in advance
>>Dennis
>
>Don't know your DBMS but I had the same problem for MySql. My original solution was to CAST as a DECIMAL field but in another forum I found the following link
>
>http://saltydogllc.com/?p=193
>
>which shows a way of altering your connection string to support BigInt fields.

Thanks for sharing. I'm guessing it's MySQL Dennis was using.