SQL Tutorial

SQL UPPER and LOWER Functions

SQL Upper function allow you to convert all characters in a string into uppercase. Otherwise SQL lower function allow you to convert all characters in a string into lowercase. Here is an example of using sql upper an lower functions :

SELECT UPPER('Upper'), 
       LOWER('Lower')

And the output is:

UPPER('Upper')  LOWER('Lower')
--------------  --------------
UPPER           lower

In some RDBMS upper  and lower function are implements as UCASE or LCASE such as IBM DB2. MySQL also use UCASE and LCASE as synonyms.

Read On