View Source

Returns true if the second string evaluates to be an exact match of the first string. Source values can be string literals, column references, or expressions that evaluate to strings.

String literal reference example:

exact('a','a')

Output: Returns true, since the values are identical.

String literal reference example:

exact('a','A')

Output: Returns false, since the capitalization is different between the two strings.

Column reference example:

exact(string1,string2)

Output: Returns the evaluation of string1 column values being exact matches with the corresponding string2 column values.

exact(string_ref1,string_ref2)

Argument	Required?	Data Type	Description
string_ref1	Y	string	Name of first column or first string literal to apply to the function
string_ref2	Y	string	Name of second column or second string literal to apply to the function

string_ref1, string_ref2

String literal, column reference, or expression whose elements you want to compare based on this function.

Required?	Data Type	Example Value
Yes	String literal, column reference, or expression evaluating to a string	`myString1, myString2`

string_ref1, string_ref2

Example - Simple string comparisons