right function

Applies to: Databricks SQL Databricks Runtime

Returns the rightmost len characters from the string str.

right(str, len)

• str: A STRING expression.
• len: An integral number expression.

A STRING.

If len is less than or equal to 0, an empty string.

> SELECT right('Spark SQL', 3);
 SQL

• substr function
• substring function
• left function