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

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Query and modify data » Queries » The WHERE clause: Specifying rows


Row matching 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". You could execute the following query to search for employees that 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.

 See also