CONCAT

Join strings with CONCAT.

With CONCAT you join texts. The || operator does the same.

SELECT CONCAT(name, ' ', city) AS etiket FROM customers;

This query joins name and city with a space between.

CONCAT(name, ' ', city) AS etiket is selected from customers.

CONCAT — details

CONCAT treats NULL as empty text; || returns NULL if any operand is NULL. This difference matters.

Join name and city with a space as label from customers.

Show example solution

SELECT CONCAT(name, ' ', city) AS etiket
FROM customers

Concatenate

SELECT ____(name, ' ', city) FROM customers;

Show answer

SELECT CONCAT(name, ' ', city) FROM customers;