RIGHT (Report Builder)
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)