nysiis(X)
Returns the NYSIIS hash of a given value.
Syntax
nysiis(X)Input
| Argument | Type | Description |
|---|---|---|
X |
text | A column name |
Return Value
Returns a text string corresponding to the phonetic hash of X translated
using the NYSIIS (New York State Identification and Intelligence System) algorithm.
If X is N/A, the result is N/A.
Sample Usage
value |
nysiis(value) |
|---|---|
| 'Smith' | 'snat' |
| 'Smythe' | 'snyt' |
| 'Schmidt' | 'snad' |
| '' | NA |
Additional Information
- This function is not Unicode (UTF-8) compliant.