Chapter 7, Problem 82P

Program Plan Intro

“SELECT” command:

The “SELECT” command is used to retrieve data in a database.

Syntax for selecting values from the table is as follows:

SELECT COLUMN_NAME1, COLUMN_NAME2 FROM TABLE_NAME;

“LIKE” operator:

• • In a “WHERE” clause, the “LIKE” operator is used to search for a particular pattern in a column.
• • The “%” represents 0, 1, or many characters and “_” represents a single character.
• • In MS Access, “*” is used instead of “%” and “?” is used instead of “_”.