Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Matching rows by sound

With the SOUNDEX function, you can match rows by sound. For example, suppose a phone message was left for a name that sounded like "Ms. Brown". Which employees in the company have names that sound like Brown?

List employees with a last name that sound like Brown

• In Interactive SQL, execute the following query:

  SELECT Surname, GivenName
     FROM Employees
     WHERE SOUNDEX( Surname ) = SOUNDEX( 'Brown' );

  Surname	GivenName
  Braun	Jane

The algorithm used by SOUNDEX makes it useful mainly for English-language databases.

For more information, see SOUNDEX function [String].