Right

right returns the rightmost characters from a string, including spaces. You specify the number of characters to be returned.

Syntax

Copy
right(expression, limit)

Arguments

expression

The expression must be a string. It can be the name of a field that uses the string data type, a literal value like '12 Main Street', or a call to another function that outputs a string.

limit

The number of characters to be returned from expression, starting from the last character in the string.

Return type

String

Example

The following example returns the last five characters from a string.

Copy
right('Seattle Store#14', 12)

The following value is returned.

Copy
tle Store#14