Null versus empty quotes

R

Razor

Hi,

When does a filter test positive (i.e. return a record)
for:

is null
--versus--
empty quotes ("")

The cell looks the same in both cases, so how can I tell
which filter to use?

Do I have to test both to be safe?

Thanks!
Razor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Testing for null 4
How to return Max date or Null (if there is a Null present) 4
sorting: cleared/null v/s "" 3
Join on an Empty Field 3
M.S. Word 365 1
Filter query so the only records displayed have 4 null fields 2
OpenDataSource + Statement option 0
WHERE clause for a NULL/Empty field 2

Top