Related Topics: | ||
Description: RIGHT returns the last character or characters in a text string.
Syntax: RIGHT(Text, [Num_chars])
Text is the text string containing the characters you want to extract.
Num_chars specifies the number of characters you want RIGHT to extract.
Remarks:
Num_chars must be greater than or equal to 0.
If Num_chars is greater than the length of Text, RIGHT returns all of Text.
If Num_chars is omitted, it is assumed to be 1.
Example:
RIGHT("Sale Price", 5) = Price [the last 5 characters of the string]
RIGHT("Stock Number") = r [the last character of the string]
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.