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.