• Login

DataSoft Corporation

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
 DataSoft Store  Knowledgebase  Contact Us
 Sitemap  Privacy Policy
    Customer Service


Copyright © 2019 DataSoft Corporation All rights reserved.