• 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:








Thursday, 18 April 2019 Posted in String Functions
   Knowledgebase  Contact Us
 Sitemap  Privacy Policy
    Customer Service

Copyright © 2020 DataSoft Corporation All rights reserved.