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". You could execute the following query to search for employees that 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. See SOUNDEX function [String].
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|