CONCAT

How can we merge first and last names into a full name?

Advanced⏱ 3 Minutes⭐ 1480 XP

🤔 THE QUESTION

How can we merge first and last names into a full name?

💡 WHAT IS IT?

CONCAT() joins two or more strings together into a single combined string.

🎯 WHAT IS IT USED FOR?

Full name formatting, creating composite keys, formatting postal addresses.

💻 EXAMPLE

SELECT
CONCAT(first_name, ' ', last_name) AS full_name
FROM employees;

Practice typing production-grade SQL code for CONCAT.