SQL · Functions and expressions

concat()

Joins strings, treating NULL as an empty string. The || operator returns NULL if any side is NULL.

sqlRunnable example sql course

Syntax

concat(a, b)

Example

Open in the lab

SELECT concat('Edu', 'Byte') AS name;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.