Example 1:
Last Name = ‘Smith’
Retrieves all records with “Smith” in the Last Name field.
(This result could also have been obtained with a simple
search as described on page 4-15.)
Example 2:
(Last Name = ‘Smith’) OR (Last Name =’Jones’)
Retrieves all records with “Smith” in the Last Name field
and all records with “Jones” in the Last Name field.
Example 3:
(Last Name = ‘Smith’) OR (Last Name = ‘Jones’) AND
(Dept = ‘Mfg’)
Retrieves records with either “Smith” or “Jones” in the
Last Name field, but only if those records also have
“Mfg” in the Dept field.
Example 4:
ID No BETWEEN ‘123450’ AND ‘123475’
Retrieves records with ID numbers between 123450 and
123475.
Example 5
(Last Name NOT ‘Smith’) AND (Dept = ‘Mfg’)
Retrieves all records except those with “Smith” in the
Last Name field, but only if those records also have
“Mfg” in the Dept field.
Syntax errors
If you create an invalid search statement, the ID-4000
usually displays an appropriate message. In some
instances, however, an invalid search statement may
cause a “Q&E” error or a “No matching records found”
message when you execute the search.
Saving search criteria
If you wish, you can save simple or advanced search
criteria for future use. (You cannot view or edit a saved
search, however.)
ID-4000 operation 4-23
