RIGHT

Returns a sub-string from the right part of a text string.

Syntax:

RIGHT(text {, length})

Returns the length rightmost characters of the text string.

If the length parameter is omitted, 1 is assumed.

Starting with 1.36, a length of zero is allowed (for consistency with the MID() function).

Example:

RIGHT("Thunderbird", 4)

returns the text string "bird".