Text & patterns Scalar

substr()

Extracts substring starting from character start up to the end of the string. If optional argument length is set, extracts a substring of length characters instead. Note that a start value of 1 refers to the first character of the string.

Alias of substring()

Arguments & returns

2 overloads

`substr(string, start)`

Scalar

Overload link	`string`	`start`	Returns
#01	`VARCHAR`	`BIGINT`	`VARCHAR`

`substr(string, start, length)`

Scalar

Overload link	`string`	`start`	`length`	Returns
#02	`VARCHAR`	`BIGINT`	`BIGINT`	`VARCHAR`

Example

1 more ↓

SELECT substring('Hello', 2);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

More examples

SELECT substring('Hello', 2, 2);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3