>>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 :-).
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham