Skip to main content

RIGHT

Returns the rightmost len characters from the string str, or NULL if any argument is NULL.

Syntax​

RIGHT(<str>, <len>);

Arguments​

ArgumentsDescription
<str>The main string from where the character to be extracted
<len>The count of characters

Return Type​

VARCHAR

Examples​

SELECT RIGHT('foobarbar', 4);
+-----------------------+
| RIGHT('foobarbar', 4) |
+-----------------------+
| rbar                  |
+-----------------------+
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today