>Hi all,
>How can I count the fields with .NULL value?
>Im using an sql with "'count" but always getting the result 0.
>thanks

SELECT COUNT(*) as countnotnull
,   COUNT(NVL(NULLABLEFIELD,.T.)) as countnullalso;
,   COUNT(ICASE(ISNULL(NULLABLEFIELD),.T.)) AS countnullonly     FROM ...