Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
1. Introduction
Simple text functions
How to modify Strings


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!


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).