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