right()

Extract the right-most count characters.

Reference: DuckDB 2.0.0

Arguments & returns

right(string, count)

Scalar
Overload link stringcount Returns
#01 VARCHARBIGINT VARCHAR

Example

right 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 β†—