U.M. (Windows)

4-22 FileMaker Pro User’s Guide
You can perform finds on related fields. See “Finding and omitting
related records” on page 10-34.
Finding information in different field types
In specific field types, you can find:
1 text that matches a word, phrase, or a string of characters in a text
field or in a calculation field that produces a text result
1 text characters that aren’t indexed (literal text)
1 numbers in a number field or in a calculation field that produces a
numeric result
1 dates in a date field or in a calculation field that produces a date result
1 times in a time field or in a calculation field that produces a time result
Note To find data in a container field, create a text or number field that
describes or identifies the contents of the container field. Then find the
value in the text or number field.
Finding text
Choose FileMaker Help Index from the Help menu, and then type:
E find requests, defining
To find this in a text field Type this in the field Example
Words that start with specific
characters
The specific characters Chris Smith finds Chris
Smith, Chris Smithson, and
Smith Christenson
A word that is part of a field’s
contents
An equal sign (=) before the
word
=John finds John and John
Smith (but not Johnson)
An exact word and nothing
else
Two equal signs (==) before
the word
==John finds John only
==John Smith finds
John Smith (but not
Smith John)
Exact matches on several
words in the same text field
An equal sign (=) before each
word in the search criterion in
that field
=Chris =Smith finds
Chris Smith or Smith Chris
(but not Christopher
Smithwick)
Words that vary by one or
more characters
One wildcard character (@)
for each unknown character
Gr@y finds Gray and Grey
Words that vary by more than
one character
The wildcard character (*)
for all unknown characters
McK*ie finds McKechnie and
McKenzie
?