UPPER Function

All alphabetical characters in the input value are converted to uppercase in the output value.

Input can be a column reference or a string literal.

Basic Usage

Column reference example:

upper(MyName)

Output: Returns the values from the MyName column written in UPPER.

String literal example:

upper('Hello, World')

Output: Returns the string: HELLO, WORLD.

Syntax

upper(column_string)

ArgumentRequired?Data TypeDescription
column_stringYstringName of the column or string literal to be applied to the function

For more information on syntax standards, see Language Documentation Syntax Notes.

column_string

Name of the column or string constant to be converted.

  • Missing string or column values generate missing string results.
  • String constants must be quoted ('Hello, World').
  • Multiple columns and wildcards are not supported.

Usage Notes:

Required?Data TypeExample Value
YesString literal or column referencemyColumn

Examples

Example - uppercase, lowercase, propercase functions

Source:

In the following example, you can see a number of input values in the leftmost column. The output columns are blank.

inputuppercaselowercasepropercase
AbCdEfGh IjKlMnO


go West, young man!


Oh, *(*$%(&! That HURT!


A11 w0rk and n0 0play makes Jack a dull boy.


Transformation:

To generate uppercase, lowercase, and propercase values in the output columns, use the following transforms:

Transformation Name Edit column with formula
Parameter: Columns uppercase
Parameter: Formula UPPER(input)

Transformation Name Edit column with formula
Parameter: Columns lowercase
Parameter: Formula LOWER(input)

Transformation Name Edit column with formula
Parameter: Columns propercase
Parameter: Formula PROPER(input)

Results:

inputuppercaselowercasepropercase
AbCdEfGh IjKlMnOABCDEFGH IJKLMNOabcdefgh ijklmnoAbcdefgh Ijklmno
go West, young man!GO WEST, YOUNG MAN!go west, young man!Go West, Young Man!
Oh, *(*$%(&! That HURT!OH, *(*$%(&! THAT HURT!oh, *(*$%(&! that hurt!Oh, *(*$%(&! That Hurt!
A11 w0rk and n0 0play makes Jack a dull boy.A11 W0RK AND N0 0PLAY MAKES JACK A DULL BOY.a11 w0rk and n0 0play makes jack a dull boy.A11 W0rk And N0 0play Makes Jack A Dull Boy.