Beginner

303. CONCAT Function

Learn how to combine multiple text values into a single string.

📘 Lesson 303 of 728 ⏱ 9 min 🎯 Beginner

The CONCAT function combines two or more string expressions into one text value.

Business data is often stored across multiple columns. CONCAT allows analysts to create combined labels and readable output.

Combine first name and last name into a full name.

SQL 
SELECT
    CONCAT(FirstName, ' ', LastName) AS FullName
FROM Employees;

CONCAT is useful in customer reporting, employee directories, address formatting, labels, and data preparation.

  • CONCAT combines text values.
  • Multiple expressions can be combined.
  • It is useful for creating labels.
  • It can combine names and addresses.
  • NULL behavior can vary by database.
What does CONCAT do?

CONCAT combines multiple text expressions into one string.

Why is CONCAT useful for analysts?

It allows analysts to create readable labels by combining values stored in separate columns.

Have you finished this lesson?

Introduction to SQL – All Lessons