Difference between revisions of "+ (string)"
From SQLZOO
| Line 37: | Line 37: | ||
<li>[[TRIM |TRIM function]]</li> | <li>[[TRIM |TRIM function]]</li> | ||
</ul> | </ul> | ||
| + | |||
| + | {{Languages}} | ||
Revision as of 08:49, 6 September 2012
| s1 + s2 | ||
|---|---|---|
| Engine | OK | Alternative |
| ingres | Yes | |
| mysql | No | CONCAT(s1,s2) |
| oracle | No | s1 || s2 |
| postgres | No | s1 || s2 |
| sqlserver | Yes | |
+ (strings)
+ allows you to stick two or more strings together.
This operation is concatenation.
s1 + s2
In this example you put the region and the name together for each country.
SELECT CONCAT(region,name) FROM bbc
SELECT region || name FROM bbc
SELECT region + name FROM bbc
See also
| Language: | English • Deutsch |
|---|
