Apple AppleWorks 5 : Mac OS - Manual (Page 207)

Database 8-25
To narrow your search, you can use relational operators (such as < and >),
enter values in multiple fields, or require that a record meet either one set of
search criteria or another. There are many ways to combine different search
methods. The following table provides some common examples.
For example,
to find In Find mode, do this in the
find request
Example
Only records that
contain a specific
value Type or select the value.
Only records that
contain a set of
specific values Type or select the set of
values.
All records that contain
one or the other set of
values Type or select the first value
or set of values and then
choose New Request from the
Edit menu. Enter another value
or set of values in the new find
request.
All records that do not
contain a specific value Type <> or
≠
(Option-=)
before the value to find records
not including empty fields. Or,
type or select the value, and
then click the Omit box to find
all records (including ones
with empty fields).
Records with a value
less than a specific
number Type < before the value.
* Choose Index from the or Help menu and scroll to the entry. Then choose a topic from
the list and click Go To Topic.
In the Help index, * see:
E
New Request command
E
operators
Finds the Italian restaurants
Finds the Italian restaurants that
have been reviewed
Finds the Italian restaurants and any
restaurant in Calistoga
Finds all restaurants not in Napa
Finds restaurants with average meal
prices less than $10