17.05 - StringSimilarity Input - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Analytic Functions

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1206-170K
Column Data Type Description
column1 CHARACTER or VARCHAR [Column appears once for each specified column1.] String to compare to string in column2.
column2 CHARACTER or VARCHAR [Column appears once for each specified column2.] String to compare to string in column1.
accumulate_column Any [Column appears once for each specified accumulate_column.] Column to copy to output table.

If any column1 or column2 in the input table schema supports more than 200 characters, you must cast it to VARCHAR(200). See example in StringSimilarity Syntax Elements.