> Can somebody come up with a realistic scenario where they would > actually want SUM() to return NULL instead of 0? NULL is such
I think your example of totaling sales in October makes the argument itself - you didn't make sales totaling $0 in October, you just didn't make any sales. A subtle but irritatingly big difference. :) -Tom
