Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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?
In Interactive SQL, execute the following query:
SELECT Surname, GivenName FROM Employees WHERE SOUNDEX( Surname ) = SOUNDEX( 'Brown' );
The algorithm used by SOUNDEX makes it useful mainly for English-language databases.
For more information, see SOUNDEX function [String].