RIGHT( ) Function

Example   See Also

Returns the specified number of rightmost characters from a character string.

Syntax

RIGHT(cExpression, nCharacters)

Returns

Character

Arguments

cExpression

Specifies the character expression whose rightmost characters are returned.

nCharacters

Specifies the number of characters returned from the character expression. RIGHT( ) returns the entire character expression if nCharacters is greater than the length of cExpression. RIGHT( ) returns an empty string if nCharacters is negative or 0.

Remarks

Characters are returned beginning with the last character on the right and continuing for a specified number of characters.