>>>I see that CAST() resolves the issue with NULL. I will use the SUM() though. Thank you.
>>
>>For me this is a BUG.
>>This is stupid error "SQL: cannot determine datatype of SQL Column: COUNT_0"
>>What could be the type of COUNT()?
>>Maybe char or memo?
>>:-)
>
>Maybe you should send the request to VFPT for the fix in VFP 10 :-).
Yeah, sure :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.