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.

Reference: DuckDB 2.0.0

Alias of substring()

Arguments & returns

2 overloads

substr(string, start)

Scalar
Overload link stringstart Returns
#01 VARCHARBIGINT VARCHAR

substr(string, start, length)

Scalar
Overload link stringstartlength Returns
#02 VARCHARBIGINTBIGINT VARCHAR
substr example
SQL
Haybarn WASM 2.0.0-rc12 Β· In your browser

Engine example Β· Run to view results.

More examples

substr example 2
SQL
Haybarn WASM 2.0.0-rc12 Β· In your browser

Engine example Β· Run to view results.