How can I create a query to count the blank fields in the table ?

Fred
Fred used Ask the Experts™
on
How can I create a query to count the blank fields in the table ?


documentID      DocumentName                  DocumentDesc                                DocumentLink/
1021                  Working with.                      Survey                                            http://www..
1022                (blank)                                      Test                                                http://www

Meaning documentID 1022 was created but was not loaded on the Table while 1021 was created and loaded. The table as numerous blanks spaces in the DocumentName column
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
SELECT COUNT(*)  TotalDocuments
Table column
where column =  ' '  for empty string
where column  is null for null vaues

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial