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%'

Functions

Concatenate strings

Extracting substrings

lower case

Finding Substring

Formatting numbers

Replace NULL

Conditional values

Time now

Format dates