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

Question

List the customer ID and first and last names for all customers located in the city of Cody. Your query should ignore case. For example, a customer with the city Cody should be included, as should customers whose city is CODY, cody, cOdY, and so on

Answer 1

Question

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;

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

List the customer ID and first and last names for all customers located in the city of Cody. Your query should ignore case. For example, a customer with the city Cody should be included, as should customers whose city is CODY, cody, cOdY, and so on

You have been told that you need to store the zip code for employees. Add a column to the EMPLOYEE table which will be used to store each employee’s zip code Update two rows in the EMPLOYEE table and assign a zip code (must have a WHERE clause). (you MAY use 1 or 2 statements) Write a query that includes each employee's last name, department name (not ID), and salary for each employee whose salary is less than the average for their department

List the owner number and last name for all owners located in the city of Seattle. Your query should ignore case. For example, a customer with the city Seattle should be included, as should customers whose city is SEATTLE, SEAttle, SeAttle, and so on. StayWell is offering a monthly discount for residents who pay their rent on a quarterly basis. The discount is 1.75 percent of the monthly fee. For each property, list the office number, address, owner number, owner’s last name, monthly rent, and discount as DISCOUNT. The discount should be rounded to the nearest dollar.