Revision as of 11:02, 28 October 2012

SUBSTR

SUBSTR allows you to extract part of a string.

   SUBSTR('Hello world', 2, 3) -> 'llo'

In this example you get the 2nd to 5th character from each country's name.

SELECT name,
       SUBSTRING(name, 2, 5)
  FROM bbc

SELECT name,
       SUBSTR(name, 2, 5)
  FROM bbc

Language:	English • Deutsch

@@ Line 1: / Line 1: @@
 <table align='right' border='1'>
 <caption>Compatibility</caption>
-<tr><th colspan='3'>SUBSTRING(s FROM i FOR j)</th></tr>
+<tr><th colspan='3'>SUBSTR(s, i, j)</th></tr>
 <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr>
 <tr><td align='left'>ingres</td><td>Yes</td><td>[[SUBSTRING(ansi) |SUBSTRING(s FROM i FOR j)]]</td></tr>
+<tr><td align='left'>mysql</td><td>Yes</td><td>[[SUBSTRING(ansi) |SUBSTRING(s FROM i FOR j)]]</td></tr>
 <tr><td align='left'>oracle</td><td>Yes</td><td></td></tr>
 <tr><td align='left'>postgres</td><td>Yes</td><td>[[SUBSTRING(ansi) |SUBSTRING(s FROM i FOR j)]]</td></tr>
 <tr><td align='left'>sqlserver</td><td>No</td><td>[[SUBSTRING |SUBSTRING(s,i,j)]]</td></tr>
 </table>
 <h1> SUBSTR</h1>
 <p>SUBSTR allows you to extract part of a string. </p>
@@ Line 16: / Line 18: @@
 <div class='ht'>
-In this example you put the region and the name together for each country.
+In this example you get the 2nd to 5th character from each country's name.
 <source lang='sql' class='def e-sqlserver'>
 SELECT name,
@@ Line 29: / Line 31: @@
 </source>
 </div>
+{{Languages}}