FileMaker – Field Find Operators

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.