>With VFP 9, if you SUM a column and the where clause doesn't return any data, you end up with NULL. How can I obtain 0?

Try

NVL(SUM(...), 0))