Returns |
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 [,ignore_case]) |
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 |
ignore_case | N | string | When true , matching is case-insensitive. Default is false . |
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 |
When true
, matches are case-insensitive. Default is false
.
NOTE: This argument is not required. By default, matches are case-sensitive. |
Required? | Data Type | Example Value |
---|---|---|
No | String literal evaluating to a Boolean | 'true'
|