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
17. Function replace – practice
Revision

## Instruction

Fantastic! Let's do one more exercise.

## Exercise

For each slogan, show the item name and the slogan with all the full stops (.) replaced by exclamation marks (!).

### Stuck? Here's a hint!

Remember you will need to join two tables in order to get all the columns.