User's Guide

Part II. Tutorials

Chapter 7. Selecting Data from Database Tables

With the SOUNDEX function, you can match rows by sound, as well as by spelling. 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?

To list employees with surnames that sound like Brown:

• Type the following:

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

emp_lname	emp_fname
Braun	Jane

Jane Braun is the only employee matching the search condition.