XPost: microsoft.public.sqlserver.programming   
   From: aaa@aaa.com   
      
   I tried   
   CASE EventID when NULL then 1 else 0 end   
      
   It always return 0, why ?   
      
      
   "Phil Hunt"  wrote in message   
   news:j6a2kf$3d5$1@speranza.aioe.org...   
   > How do I count a column that is NULL without CASE. I was looking at NULLIF   
   > and ISNULL, they can't seem to do the job.   
   >   
   > Thanks   
   >   
   > Sorry about double posting, I replied to my question by mistake.   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)