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
1. Introduction
Concatenation
Simple text functions
How to modify Strings
Summary

Instruction

In this part, we'll teach you some basic T-SQL string functions. They'll help you manipulate text values in your queries. You will learn how to:

  • concatenate (combine) multiple text values into one value,
  • convert text to uppercase and lowercase,
  • convert text to display the characters in reverse order,
  • select substrings and find their position in a string,
  • replace parts of a string.

We're going to work with some data from a marketing agency. Let's find out more!

Exercise

Select all columns from the Item table. As you'll see, it contains:

  • item identifiers (the Id column),
  • names (the Name column),
  • basic item descriptions (the Type column).