Functions
EXACT
Case-sensitive string comparison
Try it
When to use it
When should I use EXACT instead of the = operator?
Use EXACT for a case-sensitive text comparison; the = operator ignores case, so Apple = apple is TRUE but EXACT(Apple, apple) is FALSE.
Does EXACT compare case?
Yes — EXACT returns TRUE only when both strings match exactly, including upper and lower case.
Use cases
Detect a case difference between two words
Confirm two single characters match exactly
Used in
Syntax
EXACT(text1, text2)