CONCAT

Source data — Pattern 3: Built-in Functions

All queries run against the shared employees table (see schema.sql). This pattern needs two columns not used before: hire_date (topic 17) and bonus, nullable (topics 19–20).

---

What it does

CONCAT() joins strings together. Most databases also support the || operator as shorthand (SQL Server uses + instead) — CONCAT() is the more portable choice since it works the same way almost everywhere.

Problem

Display full name by combining first and last names.

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

Result