Revision as of 14:01, 12 July 2012 by Marek
You can put two or more strings together using the concatenate operator.
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
Use ampersand: &