EXACT(t1,t2)
- and are text string.
Description
- This function checks the two text string values are identical or not.
- This function will give the result in a logical values.
- The result is TRUE when the two strings are similar and the result is FALSE when the two strings are different.
- function is the similar to the comparison operator (==).
- So we can use the operator(==) instead of this function.
- The string values we have to give with in double quotes.
Examples
- EXACT("life","life") = TRUE
- EXACT("life",Life") = FALSE
- EXACT("LIFE",Life") = FALSE
- EXACT("l ife","life") = FALSE
- EXACT("45","45") = TRUE
- EXACT("7","-7") = FALSE