How to Search for a Null Value: Difference between revisions
Jump to navigation
Jump to search
(Created page with "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...") |
No edit summary |
||
| Line 6: | Line 6: | ||
Keep in mind that these searches take longer than searches using complete words. | Keep in mind that these searches take longer than searches using complete words. | ||
== Example == | |||
Find all ''Lecythis ''specimens without images: | |||
Revision as of 19:34, 21 July 2015
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: