Name

right — Return the specified number of characters from the end of a string.

Syntax

right(string, width)
              

The RIGHT function has the following arguments:

string

The string to extract the substring from.

width

The width of the substring to extract.

Description

Returns the last characters in a text string, based on the number of characters you specify.

Examples

Formula

Description

Result

right('foobar', 3)

Return the lasst 3 characters of 'foobar'

'bar'