Chapter 8, Problem 1SCG

Program Plan Intro

SELECT statement:

It is used to retrieve information from the table or database. The syntax for the “SELECT” statement is given below:

Syntax:

SELECT * FROM table_Name;

“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;