right function
Applies to: 
Databricks SQL Databricks Runtime
Returns the rightmost len characters from the string str.
Syntax
right(str, len)
Arguments
str: ASTRINGexpression.len: An integral number expression.
Returns
A STRING.
If len is less than or equal to 0, an empty string.
Examples
SQL
> SELECT right('Spark SQL', 3);
SQL