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

Instruction

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

Exercise

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.

Console

Code editor

Result

TableConsole