Concatenate Columns

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

Use ampersand: &

Use +

Use CONCAT

SELECT Operations

Concatenate Columns

Like

Union

Apostrophe

Full text search

Column name

Equi Join

Column name with spaces

NULL