RIGHT/RIGHTB Function
The RIGHT/RIGHTB function is one of the text and data functions. Is used to extract a substring from a string starting from the right-most character, based on the specified number of characters. The RIGHT function is intended for languages that use the single-byte character set (SBCS), while RIGHTB - for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.
Syntax
RIGHT(text, [num_chars])
The RIGHT function has the following arguments:
Argument |
Description |
text |
A string you need to extract the substring from. |
num_chars |
A number of the substring characters. It must be greater than or equal to 0. It is an optional argument. If it is omitted, the function will assume it to be 1. |
RIGHTB(text, [num_bytes])
The RIGHTB function has the following arguments:
Argument |
Description |
text |
A string you need to extract the substring from. |
num_bytes |
A number of the substring characters, based on bytes. It is an optional argument. |
Notes
How to apply the RIGHT/RIGHTB function.
Examples
The figure below displays the result returned by the RIGHT function.
Return to previous page