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
Character
Remarks
Characters are returned beginning with the last character on the right and continuing for a specified number of characters.
Example
В | Copy Code |
---|---|
CLEAR ? RIGHT('Redmond, WA', 2) && Displays WA |
See Also
Other Resources
FunctionsAT(В ) 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