ASA Getting Started
  Selecting Data from Database Tables
    Selecting rows from a table

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, type the following in the SQL Statements pane:

  SELECT emp_lname, emp_fname
  FROM employee
  WHERE SOUNDEX( emp_lname ) = SOUNDEX( 'Brown' )

  emp_lname	emp_fname
  Braun	Jane

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

For more information, see SOUNDEX function [String].