CONCAT()

CONCAT() is a SQL function in the String Functions category. Concatenates two or more strings into one string. Returns NULL if any argument is NULL. The syntax is CONCAT(string1, string2, ...). It accepts string1, string2 — strings to join. It returns concatenated string. A typical example: SELECT CONCAT(first_name, ' ', last_name) AS full_name FROM employees; A close relative is SUBSTRING(), which extracts characters from a string starting at position `start` for `length` characters. A close relative is REPLACE(), which replaces all occurrences of `from_string` with `to_string` in a string. A close relative is LENGTH(), which returns the number of characters in a string. More about this category: String manipulation — CONCAT, SUBSTRING, REPLACE, TRIM, UPPER, LOWER, LENGTH. Related String Functions entries: SUBSTRING(), REPLACE(), LENGTH(), TRIM(), UPPER(), LOWER(), LPAD() / RPAD(), INSTR(). This page is part of the free SQL Reference documentation covering 762+ statements, functions, and clauses, each with syntax, parameters, return values, and examples for MySQL, PostgreSQL, SQL Server, and SQLite.