XPost: microsoft.public.sqlserver.programming   
   From: hugo@perFact.REMOVETHIS.info.INVALID   
      
   On Sun, 2 Oct 2011 12:09:08 -0400, "Phil Hunt"  wrote:   
      
   >How do I count a column that is NULL ?   
      
   Hi Phil,   
      
   To count the number of NULL values in a column, use   
      
   SELECT SUM(CASE WHEN Column IS NULL THEN 1 ELSE 0 END) FROM YourTable;   
   --   
   Hugo Kornelis, SQL Server MVP   
   My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)