SOUNDEX
The function SOUNDEX returns an 4 character code for evaluation of the similarity of 2 string expressions.
| SQL Syntax: |
SOUNDEX( expression ) | |
| Parameters: |
expression
|
|
| Escape Syntax: |
{fn SOUNDEX( expression ) } | |
| Return Type: |
A string data type depending the data type of the expression. |
Examples:
SELECT SOUNDEX( 'Peter'), {fn SOUNDEX( 'Jonathan')}
Return Values: P360, J535
see also:
SQL String Functions
DIFFERENCE