QUE CORPORATION - Using Filemaker pro X

Exact()

Category: Text

Syntax: Exact ( originalText ; comparisonText )

Parameters: originalText ”any text expression, text field, or container field; comparisonText ”any text expression, text field, or container field.

Description: Compares the contents of any two text or container expressions. This function is case sensitive. If the expressions match, the result is 1 (True); otherwise the result is 0 (False). For container fields, not only must the data be the same, but it must also be stored in the same manner (either embedded or stored by file reference).

Examples:

Exact ( "Smith" ; "smith" )

Returns (False).

Exact ( Proper ( Salutation ) ; Salutation)

Returns 1 if the contents of the Salutation field begin with initial caps.

Exact ( Zip_Lookup::City_Name ; City_Name )

Returns 1 if the value of City_Name is exactly the same as the one stored in a related ZIP code table.

Comments:

Remember that Exact() considers the case of the two strings, whereas the = operator does not. If you need to compare two values in a conditional test, consider using If ( Exact ( A ; B ); ... instead of If ( A = B ; ... .