Introduction
1. Introduction
Concatenation
Simple text functions
How to modify strings
Revision

Instruction

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.

Exercise

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

Console

Code editor

Result

TableConsole