Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail From: "Phil Hunt" Newsgroups: comp.databases.ms-sqlserver,microsoft.public.sqlserver.programming Subject: SQL help again Date: Sun, 2 Oct 2011 12:14:11 -0400 Organization: Aioe.org NNTP Server Lines: 8 Message-ID: NNTP-Posting-Host: 1F4WqZgmZBperfMg6Tnoqw.user.speranza.aioe.org X-Complaints-To: abuse@aioe.org X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6109 X-RFC2646: Format=Flowed; Original X-Notice: Filtered by postfilter v. 0.8.2 X-Newsreader: Microsoft Outlook Express 6.00.2900.5931 X-Priority: 3 X-MSMail-Priority: Normal Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:702 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.