Returns the specified number of rightmost characters from a character string.
Syntax
RIGHTC(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. RIGHTC( ) returns the entire character expression if nCharacters is greater than the length of cExpression. RIGHTC( ) returns an empty string if nCharacters is negative or 0.
Remarks
RIGHTC( ) is designed for expressions containing double-byte characters. If the expression contains only single-byte characters, RIGHTC( ) is equivalent to RIGHT( ).
Characters are returned beginning with the last character on the right and continuing for nCharacters.
This function is useful for manipulating double-byte character sets for languages such as Hiragana and Katakana.