Show TOC

UPPER/LOWER(x)Locate this document in the navigation structure

Use

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.

x

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

x is a NULL value

NULL value

Example

SQL Tutorial, Converting Values