Only this week, get the SQL Complete Track of 9 courses in a special prize of $330$89!
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).