< Day Day Up > |
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 ; ... . |
< Day Day Up > |