Result Type

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

A substring is returned. The return type is set to the input type with the exception of CHAR. A CHAR input has a result type of VARCHAR.

The result character set is the same as the source_string character set for Unicode and Latin. The result character set is Unicode for all other supported character sets.