UPPER Function

Contents:

Expand all Collapse all

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:

derive type:single value:UPPER(MyName)

Output: All of the string values in the MyName column value are written to the new column in UPPER.

String literal example:

derive type:single value:UPPER('Hello, World')

Output: The string HELLO, WORLD is written to the new column.

derive type:single value:UPPER(column_string)

Argument	Required?	Data Type	Description
column_string	Y	string	Name of the column or string literal to be applied to the function

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

Name of the column or string constant to be converted.

Usage Notes:

Required?	Data Type	Example Value
Yes	String literal or column reference	`myColumn`

Tip: For additional examples, see Common Tasks.

Source:

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

input	uppercase	lowercase	propercase
AbCdEfGh IjKlMnO
go West, young man!
Oh, ($%(&! That HURT!
A11 w0rk and n0 0play makes Jack a dull boy.

Transform:

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

set col:uppercase value:UPPER(input)

set col:lowercase value:LOWER(input)

set col:propercase value:PROPER(input)

Results:

input	uppercase	lowercase	propercase
AbCdEfGh IjKlMnO	ABCDEFGH IJKLMNO	abcdefgh ijklmno	Abcdefgh 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.

See Also for UPPER Function:

Send Feedback