Description

SUBSTRING returns the substring of size len starting at character with index start.

Substring uses zero-based indexing, i.e., the first character is at start=0. If the requested character range is (partially) outside of the string, only the overlapping part is returned.

Supported input column types: STRING

Output column type: STRING

NULL-values: If the value is NULL, the result is NULL

Syntax

SUBSTRING ( <table.column>, start, size ) 

Examples