First Guide to SQL Anywhere Studio
   PART 3. Basic SQL
     CHAPTER 12. Selecting Data from Database Tables       

Matching rows by sound

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:

1. 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.