This article explained just what I was looking for. I adapted it to find the number of rows in each column in each table that were either a space or a null and produced a report for my manager as we are trying to clean up our database.
It was simple to adapt for my purpose!
Karen