Thanks, I didn't realize I could use nvl in SUM(nvl(foo, 0)).

>look at the nvl() function
>>Hi All:
>>
>>I'm JOINing two tables on a LEFT OUTER JOIN. So, some of the fields on the right have nulls if the join fails.
>>
>>I then get an error when I try to perform a SELECT SUM(foo) foo2. The error is 'Error 1581 Field foo2 does not accept null values'.
>>
>>Note that I am working on VFP5! It's an SBT app from 100 years ago.
>>
>>Any ideas?
>>
>>Thanks,
>>
>>Yossi