Exact
 
Purpose 
Returns 1 (true) if the contents of any two fields match; otherwise, returns 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).
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 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.