Materialize/doc/user/content/sql/functions/substring.md

---

title: "SUBSTRING function" description: "Returns substring at specified positions" menu: main:

parent: 'sql-functions'

---

SUBSTRING returns a specified substring of a string.

Signatures

substring(str, start_pos)
substring(str, start_pos, len)
substring(str FROM start_pos)
substring(str FOR len)
substring(str FROM start_pos FOR 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