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