Yes it's ANSI SQL standard behavior for SUM() and alike functions in VFP9 but previous VFP versions did not support it. See SET ENGINEBEHAVIOR for details.
>
>If I select records that don't satisfy my criteria I get 0 for count(*), but NULL for sum(IIF(myCondition, 1,0))
>
>Is this a documented behavior?
--sb--
