How to Search for a Null Value

From The New York Botanical Garden
Revision as of 21:24, 23 November 2015 by Mtulig (talk | contribs)
Jump to navigation Jump to search

It is not uncommon to want to search for records with nothing in a particular field. Which search string you use will depend on what it is that you don’t want to find. In EMu, the exclamation mark specifies NOT. Thus:

!+ in an attachment field will return all records where there is no attachment in that field.

!* in any field will return records where there is no value in a field.

Keep in mind that these searches take longer than searches using complete words.

Example

Find all Lecythis specimens without images: