16.20 - FOR - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

A keyword indicating that the searched substring is bounded on the right by the value n2.

If you omit FOR n2, then you extract the entire right hand portion of the named string or string expression, beginning at the position named by n1.

If string_expression is a BYTE or CHAR type and you omit FOR n2, trailing binary zeros or pad characters are trimmed.