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.

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.

upper(column_string)


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

column_string

Name of the column or string constant to be converted.

Required?Data TypeExample Value
YesString literal or column referencemyColumn

Example - uppercase, lowercase, propercase functions