U.M. (Windows)

Table Of Contents
Working with information in records 4-23
Keep these points in mind:
1 Searching for literal text takes longer than word searches. (See
“Indexing fields” on page 2-11.)
1 You can omit records when you define one or multiple requests. See
“Omitting records” on page 4-25.
Finding numbers, dates, and times
Whole words of literal text
(text exactly as it appears, but
regardless of uppercase or
lowercase)
Choose Literal text from the
Symbols list. Type the text,
including spaces and
punctuation, surrounded by
double quotation marks (").
"Marten and Jones
Interiors" finds Marten
and Jones Interiors but not
Jones and Marten Interiors
Partial words of literal text
(text exactly as it appears, but
regardless of uppercase or
lowercase)
Choose Literal text from the
Symbols list. Type
characters, punctuation, and
spaces exactly as they appear
in the file, surrounded by
double-quotation marks (").
Type the wildcard character
(*) to find text in the middle
of the literal text string.
*"son & Phillips" finds
Johnson & Phillips and
Paulson & Phillips
", " finds Boston, MA and
Markley Insurance, Inc.
Choose FileMaker Help Index from the Help menu, and then type:
E symbols
To find Type this in the field Example
A number in a number field or
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 .50, $.50,
and 50%
A Boolean number in a
number field or calculation
field that produces a Boolean
result
The value you’re using for
the field
Y, y, t, and T find Yes
1 finds 1
F, f, n, and N find
False
A date in a date field or
calculation field that produces
a date result
The date as digits, separated by
a nonnumeric character, in the
format used when the file was
created (unless Use System
Formats is chosen)
3/3/98 finds 3/3/98,
March 3, 1998, and
3/3/1998
To find this in a text field Type this in the field Example
?