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