RIGHT( ) Function

  • Article

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

RIGHT(cExpression, nCharacters)

Return Value

Character

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.

Remarks

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

Example

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

RATLINE( ) Function

RTRIM( ) Function

RIGHTC( ) Function

SUBSTR( ) Function

SUBSTRC( ) Function

TRIM( ) Function

Other Resources

Functions