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 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 change 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).
  • a third column which tells us what it actually is (column type).