SQL UPPER converts every letter of a string into upper case. SQL LOWER converts every letter of a string into lower case. And also if the string is attached with some numerical or special symbols, they remain unaffected by these functions.

The syntax for upper case is as follows: The syntax for lower case is as follows:

The execution of uppercase is as follows: [c] sql>SELECT UPPER('splessons'); The output of above query is SPLESSONS sql>SELECT UPPER('america'); The output of above query is AMERICA [/c] The execution of lower case is as follows: [c] sql> SELECT LOWER('ACer123'); The output of above query is acer123 sql>SELECT LOWER('SYSTEM'); The output of above query is system [/c]

• SQL LOWER - Changes a string into lower case.
• SQL UPPER  - Changes a string into upper case.