Rainbow Deals - 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 small letters, there must be a function for capital letters too, right? It's called upper() and works in a similar way:

SELECT upper(last_name)
FROM copywriter;

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


The lower case 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.

Stuck? Here's a hint!

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