Difference between revisions of "Concatenate Columns"

From SQLZOO
Jump to: navigation, search
Line 19: Line 19:
 
   FROM bbc
 
   FROM bbc
 
</source>
 
</source>
<div class="ecomm e-access">Use ampersand: &</div>
+
<div class="ecomm e-access" style="display: none">Use ampersand: &</div>
<div class="ecomm e-sqlserver"">Use +</div>
+
<div class="ecomm e-sqlserver"style="display: none">Use +</div>
<div class="ecomm e-mysql"">Use CONCAT</div>
+
<div class="ecomm e-mysql"style="display: none">Use CONCAT</div>
  
 
</div>
 
</div>

Revision as of 16:36, 10 July 2012

You can put two or more strings together using the concatenate operator.

You can put two or more strings together using the concatentate operator. The SQL standard says you should use || but there are many differences between the main vendors.

CREATE TABLE bbc (name VARCHAR(10), region VARCHAR(10));
INSERT INTO bbc VALUES ('Poland', 'Europe');
INSERT INTO bbc VALUES ('Japan', 'Asia');
SELECT region & name
  FROM bbc
SELECT region + name
  FROM bbc
SELECT CONCAT(region, name)
  FROM bbc
SELECT region || name
  FROM bbc
Use +
Use CONCAT
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense