On 9/8/05, Thomas Briggs <[EMAIL PROTECTED]> wrote: > > > > > 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. :)
Null is a big pain sometimes! :)