Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Standard SQL Functions

Introduction
Concatenation
Simple text functions
How to modify strings
17. Function replace – practice
Review

Instruction

Fantastic! Let's do one more exercise.

Exercise

For each slogan, show the item name and the slogan with all the periods (.) replaced by exclamation marks (!). Name the second column changed_text.

Stuck? Here's a hint!

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