>>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 ...
>

Incorrect.

>

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

See http://forums.asp.net/p/1374351/2890690.aspx#2890690