>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?
:-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
