RIGHT (Lakehouse v1)
Returns the rightmost len characters from the string str, or NULL if any argument is NULL.
Analyze Syntax
Section titled “Analyze Syntax”func.right(<str>, <len>)Analyze Examples
Section titled “Analyze Examples”func.right('foobarbar', 4)┌────────────────────────────┐│ func.right('foobarbar', 4) │├────────────────────────────┤│ rbar │└────────────────────────────┘SQL Syntax
Section titled “SQL Syntax”RIGHT(<str>, <len>);Arguments
Section titled “Arguments”| Arguments | Description |
|---|---|
<str> | The main string from where the character to be extracted |
<len> | The count of characters |
Return Type
Section titled “Return Type”VARCHAR
SQL Examples
Section titled “SQL Examples”SELECT RIGHT('foobarbar', 4);┌───────────────────────┐│ RIGHT('foobarbar', 4) │├───────────────────────┤│ rbar │└───────────────────────┘