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

REGEXP_SUBSTR is a scalar function whose return value data type depends on the data type associated with source_string input parameter that is passed into the function.

A source_string of:

  • CHAR, VARCHAR returns VARCHAR in the same character set as source_string.
  • CLOB returns CLOB in the same character set as source_string.