Text Functions (Report Builder)

Use Text functions to manipulate the text in your report. For example, suppose you want cities and states to be displayed together. Using the CONCAT function, you can create a field where both are displayed together.

Text functions can use the following data types: String and Integer.

In This Section

Topic	Description
CONCAT (Report Builder)	Concatenates two strings together into one.
FIND (Report Builder)	Position of the first instance of a string.
LEFT (Report Builder)	Returns the left most characters of a string.
LENGTH (Report Builder)	Returns the number of characters in a string.
LOWER (Report Builder)	Converts a string from uppercase characters to lowercase.
LTRIM (Report Builder)	Returns a string with the leading spaces removed.
REPLACE (Report Builder)	Returns a string with all the instances of a sub-string replaced by another sub-string.
RIGHT (Report Builder)	Returns the right most characters of a string.
RTRIM (Report Builder)	Returns a string with the trailing spaces removed.
SUBSTRING (Report Builder)	Returns a sub-string from within a string.
UPPER (Report Builder)	Converts a string from lowercase characters to uppercase.

See Also

Concepts

Using Functions (Report Builder)
Working with Formulas (Report Builder)
Report Builder How-to Topics

Help and Information

Getting SQL Server 2005 Assistance