Functions Reference

FILEMAKER FUNCTIONS REFERENCE 211
Examples
Code(“”) returns 0.
Code(“a”) returns 97.
Code(“b”) returns 98.
Code(“ab”) returns 9800097.
Code(“ä”) returns 228.
Code(“ä”)(an a followed by a dieresis character entered in a separate keystroke) returns
77600097.
Related topics
Contents
Functions reference (alphabetical list)
Exact
Purpose
Compares the contents of any two fields. If the fields match, the result is 1 (True); otherwise, the
result is 0 (False).
Format
Exact(originalText;comparisonText)
Parameters
originalText - any text expression, text field, or container field
comparisonText - any text expression, text field, or container field
Data type returned
number
Originated in
FileMaker Pro 6.0 or earlier
Description
For text to match exactly, the uppercase and lowercase usage must be the same. For container
fields, the data must be stored in the same manner (either embedded, or stored by reference).
Note When evaluating values, text attributes such as font, styles, and sizes are not considered.
Tip If case isn't important, use the Lower or Upper function on both parameters to process data
before checking for an exact match.
Examples
Exact(“McDonald”;“McDonald”) returns 1 (True).
Exact(“McDonald”;“MCDONALD”) returns 0 (False).