Description
Returns a code or number that represents the sound of a word.
Syntax
SOUNDEX ( TextSourceField, "connection" )
| Parameter | Description |
|---|---|
| TextSourceField | The string to be evaluated. |
| connection | The name of the connection to use. |
Remarks
Useful to populate a field that can be used to match on later. The SOUNDEX function converts a string to a code to find similar-sounding words or names. The first character of the code is the first character of the expression and the second through fourth characters of the code are numbers. Vowels in the expression are ignored unless they are the first letter of the string.
Note: To use SOUNDEX, it must be supported by the underlying data source. Therefore, SOUNDEX is only available against connections to relational databases that support the SOUNDEX feature.
Examples
The SOUNDEX for 'Smith' and 'Smythe' will return the same result because all vowels (and y) are not included.
SOUNDEX ( 'Smith', '<Target>' ) returns S530
SOUNDEX ( 'Smythe', '<Target> ) returns S530