Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the right most characters of a string.
Syntax
RIGHT(string, length)
string |
Species the string from which to obtain the right-most characters. |
length |
Specifies the number of characters to obtain. |
Example
| Formula | Result |
|---|---|
RIGHT(Email Address, 20) |
Returns the last twenty characters of each instance of the Email Address field. For example, @adventure-works.com |
RIGHT("A light yet stiff aluminum bar for long distance riding.", 21) |
long distance riding. |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Text Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Data, Text, and Images (Report Builder)