http://sqlzoo.net/w/index.php?title=Concatenate_strings&feed=atom&action=historyConcatenate strings - Revision history2013-05-24T04:54:38ZRevision history for this page on the wikiMediaWiki 1.20.4http://sqlzoo.net/w/index.php?title=Concatenate_strings&diff=1519&oldid=prevConnor at 14:16, 17 July 20122012-07-17T14:16:17Z<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:16, 17 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 10:</td>
<td colspan="2" class="diff-lineno">Line 10:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang=sql class='setup'></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang=sql class='setup'></source></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-access'>SELECT name & ' is in ' & region</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-access'>SELECT name & ' is in ' & region</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>   FROM <del class="diffchange diffchange-inline">cia</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   FROM <ins class="diffchange diffchange-inline">bbc</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   WHERE name LIKE 'D%'</source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   WHERE name LIKE 'D%'</source></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlserver'>SELECT name + ' is in ' + region</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlserver'>SELECT name + ' is in ' + region</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>  FROM <del class="diffchange diffchange-inline">cia</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>  FROM <ins class="diffchange diffchange-inline">bbc</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  WHERE name LIKE 'D%'</source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  WHERE name LIKE 'D%'</source></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-mysql'>SELECT CONCAT(name, ' is in ', region)</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-mysql'>SELECT CONCAT(name, ' is in ', region)</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>   FROM <del class="diffchange diffchange-inline">cia</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   FROM <ins class="diffchange diffchange-inline">bbc</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   WHERE name LIKE 'D%'</source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   WHERE name LIKE 'D%'</source></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'>SELECT name || ' is in ' || region</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'>SELECT name || ' is in ' || region</div></td></tr>
</table>Connorhttp://sqlzoo.net/w/index.php?title=Concatenate_strings&diff=1518&oldid=prevConnor: Created page with "Concatenate strings. <div class='ht'> <div class=params>schema:gisq</div> <div> Concatenation means "stick strings together". In this example we concatenate three strings, '''..."2012-07-17T14:15:34Z<p>Created page with "Concatenate strings. <div class='ht'> <div class=params>schema:gisq</div> <div> Concatenation means "stick strings together". In this example we concatenate three strings, '''..."</p>
<p><b>New page</b></p><div>Concatenate strings.<br />
<div class='ht'><br />
<div class=params>schema:gisq</div><br />
<div><br />
Concatenation means "stick strings together".<br />
In this example we concatenate three strings, '''name''' and '''region''' are string attributes of the table, ' '''is in''' ' is a string literal.<br />
</div><br />
<source lang=sql class='tidy'><br />
</source><br />
<source lang=sql class='setup'></source><br />
<source lang='sql' class='def e-access'>SELECT name & ' is in ' & region<br />
FROM cia<br />
WHERE name LIKE 'D%'</source><br />
<source lang='sql' class='def e-sqlserver'>SELECT name + ' is in ' + region<br />
FROM cia<br />
WHERE name LIKE 'D%'</source><br />
<source lang='sql' class='def e-mysql'>SELECT CONCAT(name, ' is in ', region)<br />
FROM cia<br />
WHERE name LIKE 'D%'</source><br />
<source lang='sql' class='def'>SELECT name || ' is in ' || region<br />
FROM bbc<br />
WHERE name LIKE 'D%'</source><br />
<br />
<br />
<div class="ecomm e-oracle" style="display: none"></div><br />
</div><br />
{{Functions ref}}</div>Connor