This lesson covers all scalar functions from the course that deal with strings:
CONCAT(text1, text2, …)
The CONCAT()
functions accept the arbitrary number of arguments and joins them together.
It’s really useful to generate URL-s from the database records. Here’s an example of such a query:
SELECT id, name, genre, CONCAT('https://admin.bindle.com/books/', id, '/edit') AS admin_tool_url FROM books
LENGTH(text)
The LENGTH()
function returns the number of characters in the text input:
SELECT LENGTH(first_name) FROM users ORDER BY 1 DESC
The ...
Sign up and check out 36 free lessons and exercises.
About SQL Habit
Hi, it’s Anatoli, the author of SQL Habit. 
SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst
and solve real-life challenges from Business, Marketing, and Product Management.
SQL Habit course is made of bite-sized lessons (you’re looking at one atm) and exercises. They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work. 