{ UPPER | LOWER } ( <character value expression> )

§

The UPPER function converts the source string to upper case.

§

The LOWER function converts the source string to lower case.

§

The data type of the result is the declared type of the argument.

§

If the argument is null, then the result is null.

Expression

Result

UPPER( 'Hello World' )

'HELLO WORLD'

LOWER( 'Hello World' )

'hello world'

SQL:2003 standard

-

Core SQL