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 |
SQL Tutorial, Converting Values