SOUNDS LIKE Operator

The XDB Server supports a SOUNDS LIKE operator that uses a soundex algorithm to pattern match strings that sound alike. The syntax for a SOUNDS LIKE condition is:

field-name SOUNDS LIKE string

where:

field-name Refers to a specific column containing the data values to be searches for a match.
string Is any character string (enclosed in quotes) to be matched against the value of the field-name column in each data record.

For example, the following query retrieves all records from the EMPLOYEE table where the LNAME column value sounds like "herwood":

SELECT fname, lname
  FROM employee
  WHERE lname SOUNDS LIKE "herwood"

The query results appear next:

fname lname
Roger Hurwood
Susan Hurwood