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

Common Functions in MS SQL Server

Introduction
Concatenation
Simple text functions
How to modify Strings
Summary

Instruction

Very good! Let's do one more exercise.

Exercise

For each slogan, print the following:

X. Y

where X is the item Name and Y is the Text of the slogan.

Print the item name in uppercase letters. Print only the slogans that contain a digit or a 'v'. Name the column ItemText.

Stuck? Here's a hint!

Remember to add the period and the space in the middle!