Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Simple text functions
10. Function upper
How to modify strings


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'.


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.