>
>because SUM() doesn't count records match the WHERE clause:
>
>CREATE CURSOR test (item I NULL DEFAULT NULL)
>APPEND BLANK
>SELECT SUM(ITEM) AS SUM;
> , COUNT(*) AS MATCH_COUNT;
> , COUNT(ITEM) AS NOT_NULL_ITEM;
>FROM TEST WHERE .T.
>
Thank you for illustrating the point.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham