How to: |
The SOUNDEX function analyzes a character string phonetically, without regard to spelling. It converts a source string to 4-character code. The first character must be the first character in the string. The last three characters represent the next three significant sounds in the source string.
SOUNDEX(length, source_string, output_format)
where:
Alphanumeric
Is the string whose numeric characters specify the number of characters in the source_string. It should be two characters long because the number must be from 1 to 99; a number greater than 99 causes the function to return asterisks (***).
Alphanumeric
Is the string to analyze.
Alphanumeric
SOUNDEX analyzes LAST_NAME phonetically and stores the result in a column with the format A4.
SOUNDEX('15', LAST_NAME, 'A4')
| iWay Software |