EXACT(text1, text2)

The EXACT function checks to see if two text values are identical. TRUE is returned if they are, FALSE if not.

EXACT is case sensitive.

For example, suppose a field called myfield contains the text "Happy today", the following results are obtained:

EXACT("Happy today", myfield)  TRUE

EXACT("happy today", myfield)  FALSE

EXACT("Happy", myfield)  FALSE

See also:

Other text functions