User manual

Chapter 2 | Using databases 34
Note To find case-sensitive text (for example, fred finds fred but not Fred), change the default
language for indexing the field to Unicode. This procedure will change the order in which records
sort. For more information, see Help.
Finding numbers, dates, times, and timestamps
When you enter criteria in a find request, 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 57.
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.”
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
Exact matches of whole words you
specify (match whole word)
= =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
Words that contain Japanese
Hiragana, Katakana, and Kanji
characters (Japanese-indexed fields
only)
The characters 京都 finds 京都 , 東京都 , and 京都府
Kana characters in a Japanese-
indexed field without differentiating
between Hiragana/Katakana,
Voiced/Semi-Voiced/Unvoiced Kana,
Small/Regular Kana, and Kana
Voiced/Unvoiced Iteration Marks
~ (tilde) and the character, to do a
relaxed search
~ は finds は , ば , ぱ , ハ , バ , and パ
Ranges of information See “Finding ranges of
information” on page 36.
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
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 .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