User manual

26 FileMaker Pro User’s Guide
Finding numbers, dates, times, and timestamps
Numbers, dates, times, and timestamps should be entered in the
corresponding field types (or calculation fields returning the
corresponding field type) to ensure correct behavior when finding
them. See
“About choosing a field type” on page 44.
Important To avoid confusion when working with dates, always use
four-digit years. For more information, see the Help topic
“Conversion of dates with two-digit years.”
Partial phrases (a sequence
of words or characters)
Characters,
punctuation, and
spaces between
quotation marks ( "" ).
Use * to find this text
in the middle of a
longer text string.
*"son & Phillips"
finds
Johnson & Phillips and
Paulson & Phillips
Case-sensitive text Change the default
language for indexing
the field to Unicode.
Note This procedure
will change the order
in which records sort.
For more information,
see Help.
fred finds fred
but not Fred
Japanese characters using a
relaxed search method that
does not differentiate
between Hiragana/
Katakana, Voiced/Semi-
Voiced/Unvoiced Kana,
Small/Regular Kana, and
Kana Voiced/Unvoiced
Iteration Marks
(Available only in
Japanese-indexed fields)
~ (tilde) followed by
the character.
~ finds , , , ,
, and
A character with special
meaning, such as database
syntax recognized by
FileMaker Pro:
@, *, #, ?, !, =, <, >, "
\ followed by the
special character.
\"Joey\" finds "Joey"
joe\@abc.net finds
the email address
[e-mail]
Exact matches of the text
you specify
== (two equal signs) ==John finds John but
not John Smith
== John Smith finds
John Smith but not
Smith, John or John
Smithers
To find
Type this in
the field Examples
Exact matches of whole
words you specify
= =Market finds Market ,
Market Services , and
Ongoing Market Research
but not Marketing or
Supermarket
=Chris =Smith finds
Chris Smith or Smith Chris
but not Chris or Christopher
Smithson
Ranges of information See “Finding ranges of
information” on
page 28.
To find
Type this in the
field Examples
A number in a number field
or in a calculation field that
produces a numeric result
The number, in the
format used when the
file was created
(unless Use System
Formats
is chosen)
.50 finds .5 , .50 , and $.50
A Boolean number in a
number field or in a
calculation field that
produces a Boolean result
1 to find True values
0 to find False values
1 finds 1
0 finds 0
To find
Type this in
the field Examples