CONCAT

From SQLZOO
Revision as of 13:18, 16 July 2012 by Connor (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
Compatibility
CONCAT(s1, s2)
EngineOKAlternative
ingresNoLENGTH(S)
mysqlNoLENGTH(S)
oracleNoLENGTH(S)
postgresNoLENGTH(S)
sqlserverYesLEN(s)

CONCAT

CONCAT allows you to stick two or more strings together.

This operation is concatenation.

   CONCAT(s1, s2 ...)   

In this example you put the region and the name together for each country.

SELECT region || name
  FROM bbc
SELECT region + name
  FROM bbc
SELECT CONCAT(region,name)
  FROM bbc

See also

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense