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' ); |
Surname | GivenName |
---|---|
Braun | Jane |
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 |