Comparison
Comparison functions provide different ways to find text values that are identical, or nearly identical, to a specified value.
Tip
If you want to find identical text values only, you can also use this simple method:
field_name = "text value"
For example: last_name = "Smith"
The text value is case-sensitive.
Function descriptions
| Function | Description |
|---|---|
|
Returns the Dice's coefficient of two specified strings, which is a measurement of how similar the two strings are. |
|
|
Returns a logical value indicating whether a string is a fuzzy duplicate of a comparison string. |
|
|
Returns the Levenshtein distance between two specified strings, which is a measurement of how much the two strings differ. |
|
|
Returns the soundex code for the specified string, which can be used for phonetic comparisons with other strings. |
|
|
Returns a logical value indicating whether a string phonetically matches a comparison string. |
