Chapter 8, Problem 2CAT

Program Plan Intro

“UPPER” keyword:

The keyword “UPPER” is used to convert the string into capital letters that is, it converts the string into upper case letters.

Syntax:

SELECT UPPER (column_Name) FROM table_Name;

“LOWER” keyword:

The keyword “LOWER” is used to convert the string into small letters that is, it converts the string into lower case letters.

Syntax:

SELECT LOWER (column_Name) FROM table_Name;