UPPER
Converts lowercase string characters to uppercase.
Syntax
UPPER( string )
The following table describes the argument for this command:
Argument | Required/ Optional | Description |
|---|
string | Required | String datatype. Passes the values you want to change to uppercase text. You can enter any valid transformation expression. |
Return Value
Uppercase string. If the data contains multibyte characters, the return value depends on the code page and data movement mode of the Data Integration Service.
NULL if a value passed to the function is NULL.
Example
The following expression changes all names in the FIRST_NAME port to uppercase:
UPPER( FIRST_NAME )
FIRST_NAME | RETURN VALUE |
|---|
Ramona | RAMONA |
NULL | NULL |
THOMAS | THOMAS |
PierRe | PIERRE |
Bernice | BERNICE |