Concatenate Columns

From SQLZOO
Revision as of 13:01, 12 July 2012 by Marek (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense