right()

Extract the right-most count characters.

Arguments & returns

right(string, count)

Scalar
Overload link stringcount Returns
#01 VARCHARBIGINT VARCHAR

Example

right example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

Apache Spark

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

SQLGlot example ↗