# UCASE or UPPER

UCASE or UPPER takes a character expression as a parameter and returns a string in which all alpha characters have been converted to uppercase.

#### Format

    UCASE or UPPER ( CharacterExpression )

If the parameter type is CHAR , the return type is CHAR. Otherwise, the return type is VARCHAR.
Note: UPPER and LOWER follow the database locale. See territory=ll_CC for more information about specifying locale.

The length and maximum length of the returned value are the same as the length and maximum length of the parameter.

    -- returns 'ASD1#W'
    VALUES UPPER('aSD1#w')

Parent topic: Built-in functions