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