Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Standard SQL Functions

Introduction
Concatenation
Simple text functions
10. Function upper
How to modify strings
Review

Instruction

Great! If there is a function for lowercase letters, there must be a function for uppercase letters too, right? It's called upper() and works in a similar way:

SELECT upper(last_name) AS last_name_uppercase
FROM copywriter;

The above query will show 'TURNER' for the last name 'Turner'.

Exercise

The lowercase fashion is now passé. Everybody started to use upper case. Show the id of each 'newspaper ad' or 'magazine ad' slogan together with its text in capital letters. Name the second column text_uppercase.

Stuck? Here's a hint!

Use two conditions in the WHERE clause, joined with OR.