Finding, sorting, and replacing data > Finding records > Finding empty or non-empty fields
 
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.
See Making a find request.
2. Refer to the following table for examples of different ways to search for empty or non-empty fields.
 
To find fields that are
Enter this in the field
Not empty (i.e., fields that have data)
*
Empty
=
3. When you’ve entered the find criteria that you want, click Perform Find in the status toolbar, or choose Requests menu > Perform Find.
To enter data in empty fields:
1. Create a find request that returns the empty field you want to replace.
2. Enter a value in the empty field in one record in the found set.
3. Choose Records menu  > Replace Field Contents.
4. Click Replace.
The value you entered is placed in every record in the found set.
Notes
If any value is empty in a repeating field, then a search using “=” returns that field.
To find empty fields formatted as a checkbox set or a radio button set, in the find request, right-click the field and choose Operators > =.