left()

Extracts the left-most count characters.

Reference: DuckDB 2.0.0

Arguments & returns

left(string, count)

Scalar
Overload link stringcount Returns
#01 VARCHARBIGINT VARCHAR

Example

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

Engine example Β· Run to view results.

In other engines

Apache Spark

SELECT LEFT(x, 2), RIGHT(x, 2)
In DuckDB
SELECT LEFT(x, 2), RIGHT(x, 2)

SQLGlot example β†—