soundex(X)
Returns the Soundex hash of a given value.
Syntax
soundex(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 Soundex algorithm.
If X is N/A, the result is N/A.
Sample Usage
value |
soundex(value) |
|---|---|
| 'Smith' | 'S530' |
| 'Smythe' | 'S530' |
| 'Schmidt' | 'S230' |
| '' | NA |
Additional Information
- This function is not Unicode (UTF-8) compliant.