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