Exact
Purpose
Returns 1 (true) if the contents of any two fields match; otherwise, returns 0 (false).
Format
Exact(originalText;comparisonText)
Parameters
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).
Notes
•When evaluating values, text attributes such as font, styles, and sizes are not considered.
Examples
Exact ( "McDonald" ; "McDonald" ) returns 1 (True).
Exact ( "McDonald" ; "MCDONALD" ) returns 0 (False).
Exact ( Upper ( "McDonald" ) ; Upper ( "MCDONALD" ) ) returns 1 (True).
Exact ( "John" ; "John " ) returns 0 (False).
Exact ( BillTo ; ShipTo ) returns 1 (True) when the value in BillTo is the same as the value in ShipTo.
Exact ( Recipient ; Upper ( Recipient ) ) returns 1 (True), when Recipient contains JOHNSON.
Exact ( Country ; "Spain" ) returns 1 (True) when the Country field contains Spain.
Related topics