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

sorry, a typo.

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

>
>>

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