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