Thank you all for the replies and insights. As it turns out, we re-imported
the spreadsheet and everything is fine now. Maybe some hic-up in the import
process? Who knows?... Thanks again, though :)

"DesertCyclist" wrote:

I have a spreadsheet with a field that may contain blanks (empty). When I
filter on that field to show only the blanks, I get 4000 records returned.
But if I import the spreadsheet into SQL Server, the test in there for blanks
('') returns nothing. However, if I test for Nulls in that field, I get 5000
records returned. I don't know which one (Excel or SQL Server) is giving me
the right answer. Can anyone help me understand what's going on?

Thanks!