Materialize Logo

SUBSTRING Function

SUBSTRING returns a specified substring of a string.

Signatures

substring ( str , start_pos , len )
Parameter Type Description
str string The base string.
start_pos int The starting position for the substring; counting starts at 1.
len int The length of the substring you want to return.

Return value

substring returns a string.

Examples

SELECT substring('abcdefg', 3) AS substr;
 substr
--------
 cdefg

SELECT substring('abcdefg', 3, 3) AS substr;
 substr
--------
 cde