RTRIM (Report Builder)

Returns a string with the trailing spaces removed.

Syntax

RTRIM(string)

string

Specifies the string from which to remove the trailing spaces.

Example

Formula	Result
RTRIM(Customer Name)	Returns each instance of the Customer Name field with any extra spaces at the end of each name removed.
RTRIM("discussion. ")	discussion.

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)

Help and Information

Getting SQL Server 2005 Assistance