User manual

44 | Using databases
Words with zero or more
unknown or variable text
characters in a row (zero or
more characters)
* for all unknown
characters
Jo*n finds Jon and John
J*r finds Jr. and Junior
*phan* finds Phan and
Stephanie
Operators or other non-
alphanumeric characters, such
as punctuation or spaces
The literal text
(characters), including
spaces and punctuation,
between double
quotation marks (")
"@" finds @ (or an email
address, for example)
"," finds records containing a
comma
" " finds three spaces in a
row
A character with special
meaning, such as the find
operators recognized by
FileMaker Pro:@, *, #, ?, !, =,
<, >, " (escape next character)
\ followed by the special
character
\"Joey\" finds "Joey"
joey\@abc.net finds the
email address [e-mail]
Words with accented
characters
The literal text
(characters), including
spaces and punctuation,
between the double
quotation marks (")
"òpera" finds òpera but not
opera
(òpera without quotes finds
both òpera and opera)
Partial phrases, a sequence of
words or characters (match
phrase from anywhere)
Characters, punctuation,
and spaces between
double quotation marks
("
"); use * to find this
text in the middle of a
longer text string
*"son & Phillips" finds
Johnson & Phillips and
Paulson
& Phillips
Exact matches of the text you
specify (match entire field)
== (two equal signs) for
a field content match
==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
φμπ10_υσερσ_γυιδε.βοοκ Παγε 44 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ