Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
1. Introduction
Simple text functions
How to modify strings


In this part, we'll teach you the basic SQL text functions to help you manipulate text values in your queries. You will learn:

  • how to concatenate multiple text values into one,
  • simple text conversions: how to put all text to uppercase, lowercase, etc,
  • how to select substrings and replace parts of the text with another text.

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


Select all columns from the table item.

As you can see, it contains:

  • item identifiers (column id),
  • names (column name)
  • and a third column which tells us what it actually is (column type).