User manual

Using databases 25
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 40. You cannot find
text in number fields.
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]
To find
Type this in
the field Examples
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
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 26.
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
To find
Type this in
the field Examples