UPPER

The string value to be converted to uppercase.

UPPER converts each string value in the specified data range to uppercase. It returns one new column for each input column, each containing the uppercase string in the corresponding input column.

This macro is available in IBM® Unica® Interact.

Examples

Temp = UPPER "gold"

Creates a new column named Temp containing "GOLD".

TEMP = UPPER( "jan 15, 1997")

Creates a new column named TEMP, which contains the ASCII text string " JAN 15, 1997 ".

TEMP = UPPER( "Pressure")

Creates a new column named TEMP, which contains the ASCII text string "PRESSURE".

TEMP = UPPER(V1)

Creates a new column named TEMP containing uppercase characters of each string in column V1.