>>SELECT COUNT(*) as countnotnull >>, COUNT(NVL(NULLABLEFIELD,.T.)) as countnullalso; >>, COUNT(ICASE(ISNULL(NULLABLEFIELD),.T.)) AS countnullonly FROM ... >>>
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 ... >>>