Concatenate strings
Concatenate strings.
schema:gisq
Concatenation means "stick strings together". In this example we concatenate three strings, name and region are string attributes of the table, ' is in ' is a string literal.
SELECT name & ' is in ' & region
FROM bbc
WHERE name LIKE 'D%'
SELECT name + ' is in ' + region
FROM bbc
WHERE name LIKE 'D%'
SELECT CONCAT(name, ' is in ', region)
FROM bbc
WHERE name LIKE 'D%'
SELECT name || ' is in ' || region
FROM bbc
WHERE name LIKE 'D%'