RIGHT

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

Syntax:

RIGHT(text {, length:number})

Returns the length rightmost characters of the text string.

If the length parameter is omitted, 1 (one) is assumed.

Example:

RIGHT("Thunderbird", 4)

returns the text string "bird".

Revisions:

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