CONCAT/de - Revision history

Peter at 17:31, 21 October 2012

2012-10-21T17:31:07Z

Peter at 17:27, 21 October 2012

2012-10-21T17:27:18Z

Peter at 17:13, 21 October 2012

2012-10-21T17:13:17Z

Peter: Created page with "Category:Deutsch
2012-10-01T10:16:35Z

Created page with "Category:Deutsch <table align='right' border='1'> <caption>Kompatibilität</caption> <tr><th colspan='3'>CONCAT(s1, s2)</th></tr> <tr><td align='center'>'''DBMS'''</td><td..."

New page
[[Category:Deutsch]]
<table align='right' border='1'>
<caption>Kompatibilität</caption>
<tr><th colspan='3'>CONCAT(s1, s2)</th></tr>
<tr><td align='center'>'''DBMS'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr>
<tr><td align='left'>Ingres</td><td>Ja</td><td></td></tr>
<tr><td align='left'>MySQL</td><td>Ja</td><td></td></tr>
<tr><td align='left'>Oracle</td><td>Nein</td><td>s1 || s2</td></tr>
<tr><td align='left'>PostgreSQL</td><td>Nein</td><td>s1 || s2</td></tr>
<tr><td align='left'>SQL Server</td><td>Nein</td><td>s1 + s2</td></tr>
</table>

<h1>CONCAT</h1>
<p>Mittels CONCAT können mehrere Zeichenketten (Strings) zu einer Zeichekkette zusammengefügt werden.</p>
<p>This operation is concatenation.</p>
<pre style='width:60ex'>
CONCAT(s1, s2 ...)
</pre>

<div class='ht'>
In diesem Beispiel werden die Region und der Name eines Landes zusammengefügt.
<source lang='sql' class='def e-oracle e-postgres'>
SELECT region || name
FROM bbc
</source>
<source lang='sql' class='def e-sqlserver'>
SELECT region + name
FROM bbc
</source>
<source lang='sql' class='def'>
SELECT CONCAT(region,name)
FROM bbc
</source>
</div>

<p>Siehe auch</p>
<ul>
<li>[[SUBSTRING | Funktion SUBSTRING]]</li>
<li>[[TRIM | Funktion TRIM]]</li>
</ul>

{{Languages}}

Kompatibilität
CONCAT(s1, s2)

'''DBMS'''