FileMaker – Field Find Operators

shopworkshelp.com/index.php?solution_id=1244
help.filemaker.com/app/answers/detail/a_id/13715...

filemaker.com/help/12/fmp/html/find_sort.5....

Finding empty or non-empty fields
You can find fields that contain no data or some data.
To find empty or non-empty fields:
1.    Start a find request.
For more information, see Making a find request.
2.    Refer to the following table for examples of different ways to search for empty or non-empty fields.
 





3.    When you’ve entered the find criteria that you want, click Perform Find in the status toolbar, or choose Requests menu > Perform Find.
Note  If any value is empty in a repeating field, then a search using “=” returns that field.

filemaker.com/help/12/fmp/html/find_sort.5....