Share via


Text Functions (Report Builder 1.0)

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

Concatenates two strings together into one.

FIND (Report Builder 1.0)

Position of the first instance of a string.

LEFT (Report Builder 1.0)

Returns the left most characters of a string.

LENGTH (Report Builder 1.0)

Returns the number of characters in a string.

LOWER (Report Builder 1.0)

Converts a string from uppercase characters to lowercase.

LTRIM (Report Builder 1.0)

Returns a string with the leading spaces removed.

REPLACE (Report Builder 1.0)

Returns a string with all the instances of a sub-string replaced by another sub-string.

RIGHT (Report Builder 1.0)

Returns the right most characters of a string.

RTRIM [(Report Builder 1.0)

Returns a string with the trailing spaces removed.

SUBSTRING (Report Builder 1.0)

Returns a sub-string from within a string.

UPPER (Report Builder 1.0)

Converts a string from lowercase characters to uppercase.