http://www.sqlzoo.net/w/index.php?title=CONCAT&feed=atom&action=history
CONCAT - Revision history
2013-05-23T06:27:59Z
Revision history for this page on the wiki
MediaWiki 1.20.4
http://www.sqlzoo.net/w/index.php?title=CONCAT&diff=4120&oldid=prev
Peter at 10:12, 1 October 2012
2012-10-01T10:12:51Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 10:12, 1 October 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 37:</td>
<td colspan="2" class="diff-lineno">Line 37:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[TRIM |TRIM function]]</li></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[TRIM |TRIM function]]</li></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">{{Languages}}</ins></div></td></tr>
</table>
Peter
http://www.sqlzoo.net/w/index.php?title=CONCAT&diff=1352&oldid=prev
Connor at 14:40, 16 July 2012
2012-07-16T14:40:27Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 14:40, 16 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 34:</td>
<td colspan="2" class="diff-lineno">Line 34:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>See also</p></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>See also</p></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>   <li>[[SUBSTRING function]]</li></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   <li>[[<ins class="diffchange diffchange-inline">SUBSTRING |</ins>SUBSTRING function]]</li></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[TRIM |TRIM function]]</li></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[TRIM |TRIM function]]</li></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td></tr>
</table>
Connor
http://www.sqlzoo.net/w/index.php?title=CONCAT&diff=1323&oldid=prev
Connor at 13:21, 16 July 2012
2012-07-16T13:21:07Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 13:21, 16 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 5:</td>
<td colspan="2" class="diff-lineno">Line 5:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>ingres</td><td>Yes</td><td></td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>ingres</td><td>Yes</td><td></td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>mysql</td><td>Yes</td><td></td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>mysql</td><td>Yes</td><td></td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><td align='left'>oracle</td><td>No</td><td><del class="diffchange diffchange-inline">[[</del>s1 || s2<del class="diffchange diffchange-inline">]]</del></td></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><td align='left'>oracle</td><td>No</td><td>s1 || s2</td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><td align='left'>postgres</td><td>No</td><td><del class="diffchange diffchange-inline">[[</del>s1 || s2<del class="diffchange diffchange-inline">]]</del></td></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><td align='left'>postgres</td><td>No</td><td>s1 || s2</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td>No</td><td>s1 + s2</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td>No</td><td>s1 + s2</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td></tr>
</table>
Connor
http://www.sqlzoo.net/w/index.php?title=CONCAT&diff=1322&oldid=prev
Connor at 13:20, 16 July 2012
2012-07-16T13:20:37Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 13:20, 16 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 3:</td>
<td colspan="2" class="diff-lineno">Line 3:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><th colspan='3'>CONCAT(s1, s2)</th></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><th colspan='3'>CONCAT(s1, s2)</th></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><td align='left'>ingres</td><td><del class="diffchange diffchange-inline">No</del></td><td><del class="diffchange diffchange-inline">[[LENGTH |LENGTH(S)]]</del></td></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><td align='left'>ingres</td><td><ins class="diffchange diffchange-inline">Yes</ins></td><td></td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><td align='left'>mysql</td><td><del class="diffchange diffchange-inline">No</del></td><td><del class="diffchange diffchange-inline">[[LENGTH |LENGTH(S)]]</del></td></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><td align='left'>mysql</td><td><ins class="diffchange diffchange-inline">Yes</ins></td><td></td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><td align='left'>oracle</td><td>No</td><td>[[<del class="diffchange diffchange-inline">LENGTH </del>|<del class="diffchange diffchange-inline">LENGTH(S)</del>]]</td></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><td align='left'>oracle</td><td>No</td><td>[[<ins class="diffchange diffchange-inline">s1 </ins>|<ins class="diffchange diffchange-inline">| s2</ins>]]</td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><td align='left'>postgres</td><td>No</td><td>[[<del class="diffchange diffchange-inline">LENGTH </del>|<del class="diffchange diffchange-inline">LENGTH(S)</del>]]</td></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><td align='left'>postgres</td><td>No</td><td>[[<ins class="diffchange diffchange-inline">s1 </ins>|<ins class="diffchange diffchange-inline">| s2</ins>]]</td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td><del class="diffchange diffchange-inline">Yes</del></td><td><del class="diffchange diffchange-inline">LEN(s)</del></td></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td><ins class="diffchange diffchange-inline">No</ins></td><td><ins class="diffchange diffchange-inline">s1 + s2</ins></td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><h1>CONCAT</h1></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><h1>CONCAT</h1></div></td></tr>
</table>
Connor
http://www.sqlzoo.net/w/index.php?title=CONCAT&diff=1321&oldid=prev
Connor: Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>CONCAT(s1, s2)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK..."
2012-07-16T13:18:15Z
<p>Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>CONCAT(s1, s2)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK..."</p>
<p><b>New page</b></p><div><table align='right' border='1'><br />
<caption>Compatibility</caption><br />
<tr><th colspan='3'>CONCAT(s1, s2)</th></tr><br />
<tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr><br />
<tr><td align='left'>ingres</td><td>No</td><td>[[LENGTH |LENGTH(S)]]</td></tr><br />
<tr><td align='left'>mysql</td><td>No</td><td>[[LENGTH |LENGTH(S)]]</td></tr><br />
<tr><td align='left'>oracle</td><td>No</td><td>[[LENGTH |LENGTH(S)]]</td></tr><br />
<tr><td align='left'>postgres</td><td>No</td><td>[[LENGTH |LENGTH(S)]]</td></tr><br />
<tr><td align='left'>sqlserver</td><td>Yes</td><td>LEN(s)</td></tr><br />
</table><br />
<h1>CONCAT</h1><br />
<p>CONCAT allows you to stick two or more strings together.</p><br />
<p>This operation is concatenation.</p> <br />
<pre style='width:60ex'><br />
CONCAT(s1, s2 ...) <br />
</pre><br />
<br />
<div class='ht'><br />
In this example you put the region and the name together for each country. <br />
<source lang='sql' class='def e-oracle e-postgres'><br />
SELECT region || name<br />
FROM bbc<br />
</source><br />
<source lang='sql' class='def e-sqlserver'><br />
SELECT region + name<br />
FROM bbc<br />
</source><br />
<source lang='sql' class='def'><br />
SELECT CONCAT(region,name)<br />
FROM bbc<br />
</source><br />
</div><br />
<br />
<p>See also</p><br />
<ul><br />
<li>[[SUBSTRING function]]</li><br />
<li>[[TRIM |TRIM function]]</li><br />
</ul></div>
Connor