RIGHT (Report Builder 1.0)

Returns the right most characters of a string.

Syntax

RIGHT(string, length)

string	Specifies 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 1.0)

Using Functions (Report Builder 1.0)

Text Functions (Report Builder 1.0)

Report Builder 1.0 How-to Topics

Working with Literals in Formulas and Filters (Report Builder 1.0)

Formatting Data, Text, and Images (Report Builder 1.0)