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

RIGHT(cExpression, nCharacters)

Parameters

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.

Return Value

Remarks

Example

	Copy Code
CLEAR ? RIGHT('Redmond, WA', 2) && Displays WA

See Also

Reference

AT( ) Function
AT_C( ) Function
ATC( ) Function
ATCC( ) Function
ATCLINE( ) Function
ATLINE( ) Function
LEFT( ) Function
LEFTC( ) Function
LTRIM( ) Function
RAT( ) Function
RATC( ) Function
RATLINE( ) Function
RTRIM( ) Function
RIGHTC( ) Function
SUBSTR( ) Function
SUBSTRC( ) Function
TRIM( ) Function

Other Resources

Functions