Only this week, get the SQL Complete Track of 9 courses in a special prize of $330$89!
Introduction
Concatenation
Simple text functions
How to modify Strings
Summary

## Instruction

Right! Let's move on to another text function: LOWER().

Whatever is passed in as an argument to LOWER() will be written in small (lowercase) letters:

SELECT
LOWER(LastName) AS LowerName
FROM Copywriter;

a9

LOWER() returns 'turner' for 'Turner'.

If there is a function for lowercase letters, there must be a function for capital (uppercase) letters too. There is! It's called UPPER() and works in a similar way:

SELECT
UPPER(LastName) AS UpperName
FROM Copywriter;

a10

UPPER() returns 'TURNER' for the last name 'Turner'.

Shall we try this in an exercise?

## Exercise

The boss of the marketing agency heard that it's very trendy to write magazine and newspaper ads in all lowercase letters. We don't want to re-enter all our slogans; let's use LOWER() instead.

For every slogan of the type N'newspaper ad' or N'magazine ad', show the slogan ID and its text in all lowercase. Name the last column TrendySlogan.

### Stuck? Here's a hint!

Use two conditions in the WHERE clause, joined with OR. Use LOWER() in the SELECT.