Introduction
Concatenation
Simple text functions
7. Function length
How to modify strings
Revision

## Instruction

Very well. Okay, now that we know the concatenation operator, let's learn some string functions. Our database knows many of them. For instance, there is a function called length() which shows the length of a string column. For example:

SELECT length(first_name)
FROM copywriter;
will show 4 for the name 'Kate', because 'Kate' consists of 4 letters.

In SQL Server this function is called len().

## Exercise

For every slogan, show its id, its text and its length.

### Stuck? Here's a hint!

Use length(text).

Code editor

TableConsole