CONCAT

Compatibility

CONCAT(s1, s2)
Engine	OK	Alternative
ingres	Yes
mysql	Yes
oracle	No	s1 || s2
postgres	No	s1 || s2
sqlserver	No	s1 + s2

CONCAT

CONCAT allows you to stick two or more strings together.

This operation is concatenation.

   CONCAT(s1, s2 ...)   

1.

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

SELECT CONCAT(region,name) FROM bbc Submit SQLrestore default

result

See also

• SUBSTRING function
• TRIM function

Language:Project:Language policy	English  • Deutsch