UPPER (Report Builder)

Converts a string from lowercase characters to uppercase.

Syntax

UPPER(string)

string

Specifies the string to convert to uppercase.

Example

Formula Result

UPPER(City)

Returns each instance of the City field with the city name displayed in capital letters. For example, Abingdon is listed as ABINGDON.

UPPER("specify")

SPECIFY

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