UPPER
Converts lowercase string characters to uppercase.
Syntax
UPPER( string )
Argument | Required/ Optional | Description |
|---|
string | Required | String datatype. Passes the values you want to change to uppercase text. You can enter any valid expression. |
Return Value
Uppercase string. If the data contains multibyte characters, the return value depends on the code page of the Secure Agent that runs the task.
NULL if a value passed to the function is NULL.
Example
The following expression changes all names in the FIRST_NAME column to uppercase:
UPPER( FIRST_NAME )
FIRST_NAME | RETURN VALUE |
|---|
Ramona | RAMONA |
NULL | NULL |
THOMAS | THOMAS |
PierRe | PIERRE |
Bernice | BERNICE |