NGRAM Function Syntax | VantageCloud Lake - NGRAM Function Syntax - Teradata Vantage

[TD_SYSFNLIB.] NGRAM ( string1, string2, length [, position ] )

Syntax Elements

TD_SYSFNLIB.

Name of the database where the function is located.

string1

A character string or string expression.

If string1 is NULL, NULL is returned.

string2

A character string or string expression.

If string2 is NULL, NULL is returned.

length

The value ninn-gram, which is the comparison length.

position

Specifies that the n-gram is a positional n-gram match.