UPPER

Converts all the characters in the string to uppercase.

Syntax

= UPPER(value)

Parameters

value

A string which is to be converted to uppercase.  The value can be specified as a decimal value (e.g., 37.48), as a string (“Word”), or as the value of a variable (e.g, FirstName).

Return Type

String

In the case of an error, the function displays an error message: “UPPER(value): Error message”

Examples

Example

Returns

= TRIM(“            Iron Speed Designer                   “)

“Iron Speed Designer”

= UPPER(“TEST”)

“TEST”

= UPPER(“Iron Speed Designer”)

“IRON SPEED DESIGNER”

= UPPER(Product)

The upper case converted version of the value of Product.

= UPPER(FirstName)

The upper case converted version of the value of FirstName.

= UPPER(RIGHT(“Iron Speed Designer”, 8))

The upper case version of the extracted string.

= UPPER(CONCATENATE(“Iron”, “Speed”, Designer”))

An uppercase version of the concatenated string.

= UPPER(“iron speed”). INSERT(10, “ DESIGNER”)

A upper case string concatenated with the string supplied to the insert function.