1. Calculation functions
  2. All Functions
  3. Miscellaneous Functions
  4. UPPER

Converts text to uppercase.

Use the optional locale parameter, if you need to make the text comparison locale-sensitive.

For example,

UPPER (x, fr) 

makes the function sensitive to French-locale variations.

Syntax

UPPER(x, [y])

where:

  • x: text
  • y: (optional) locale

Format

Input Format Output Format

x: Text

y: Locale

Text

Arguments

The function uses the following arguments:

  • x: Text: Text-formatted line item, text constant, or general expression
  • y: Text: Two character international locale code

Constraints

The function has no constraints.

Excel equivalent

Back to Top

Example

Line item myval = Sentence

Upper(myval) 

= SENTENCE

Back to Top

Similar functions