Returns a substring from the end of a string column values. The last n characters where n is the number argument.
Category: text
Syntax:
Right([text_column], number)
StringColumn
Context Filtering: ✓ Yes
Parameters
| Name | Type | Required | Description |
|---|
text_column | column | ✓ Yes | The string column from which a right substring will be returned. |
number | number | ✓ Yes | The desired length of the returned substring. |
Validation
- Minimum parameters: 2
- Maximum parameters: 2
Examples
Returns last 4 digits of each phone number.
- Left - Extract from start of string
- Contains - Search for patterns in strings
Last modified on March 13, 2026
