>>With VFP 9, if you SUM a column and the where clause doesn't return any data, you end up with NULL. How can I obtain 0? > >What About: >
>SUM(NVL(Field,0))
>
This still returns NULL. Also, I am looking for a generic setting that could be new in VFP 9 as I don't want to adjust all that everywhere in the code.