UPPER/LOWER(x)

UPPER(x) and LOWER(x) are string functions that convert a character string x (string specification) to uppercase/lowercase letters. Only expressions that produce an alphanumeric value are permitted as string specifications.

Result of the UPPER(x) or LOWER(x) function

x is a NULL value

NULL value

Examples

SQL Tutorial, Converting Values