Concatenate Columns
From SQLZoo
You can put two or more strings together using the concatenate operator.
schema:gisq
You can put two or more strings together using the concatenate operator. The SQL standard says you should use || but there are many differences between the main vendors.
SELECT region & name
FROM bbc
SELECT region + name
FROM bbc
SELECT CONCAT(region, name)
FROM bbc
SELECT region || name
FROM bbc