|
Extracts a number of characters
from a given string, beginning with the last character on the right.
Parameters
Parameter
|
Description
|
|---|
s
|
The string to extract.
|
n
|
The number of characters to extract.
If n is
greater than the length of the string, the function returns the
whole string.
If n is 0 or less, the function
returns an empty string.
|
ExamplesThe
following expressions are examples that use the Right function:
Expression
|
Returns
|
|---|
Right("ABCDEFGH", 3)
|
FGH
|
Right("Tony Blue", 5)
|
" Blue"
|
Right(Telephone[0], 7)
|
The last seven characters of the first occurrence
of Telephone.
|
Right(Rtrim(CreditCard_Num), 4)
|
The last four characters of CreditCard_Num.
See
also Rtrim.
|
|
|
|
