Text & patterns
Scalar
left()
Extracts the left-most count characters.
Reference: DuckDB 2.0.0
Arguments & returns
left(string, count)
Scalar
| Overload link | string | count |
Returns |
|---|---|---|---|
| #01 | VARCHAR | BIGINT |
VARCHAR |
Example
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)
SELECT LEFT(x, 2), RIGHT(x, 2)