LOWER (Report Builder)

Converts a string from uppercase characters to lowercase.

Syntax

LOWER(string)

string

Specifies the string to convert to lowercase.

Example

Formula Result

LOWER(Title)

Returns each instance of the Title field in all lowercase letters. For example, mr. or ms.

LOWER("PAID")

paid

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