Example

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

This example and Example use the following table data:

   SELECT family_name FROM family;
   
   family_name
   -----------
   John
   Joan
   Joey
   joanne
   michael
   Bob

Here are the results of the SOUNDEX function on the data in the family_name column:

   SELECT SOUNDEX(TRIM(family.family_name));
   
   Soundex(TRIM(BOTH FROM family_name))
   ------------------------------------
   J500
   J500
   B100
   J000
   m240
   j500