16.20 - Example - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

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