SOUNDEX (string)

Converts an alpha string to a four character code to find similar sounding words or names. Returns a four character (SOUNDEX) code to evaluate the similarity of two strings, usually a name.

Note: Conforms to the current rule set for the official implementation of Soundex used by the United States Government.

The following example illustrates use of the SOUNDEX function on the Person table finding all last names that sound like "Kennedy".

SELECT Last_Name FROM Person WHERE SOUNDEX(last_name) = SOUNDEX ('Kennedy')

Results of SELECT:

Last_Name

---------

Kandy

Kenady

Kennedy

Kennedy

 




Thursday, 18 April 2019 Posted in String Functions