Revision as of 14:15, 16 July 2012

SUBSTRING (ansi)

SUBSTRING allows you to extract part of a string.

   SUBSTRING('Hello world' FROM 2 FOR 3) -> 'llo'

In this example you put the region and the name together for each country.

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

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

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

@@ Line 4: / Line 4: @@
 <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(s,i,j)]]</td></tr>
-<tr><td align='left'>oracle</td><td>No</td><td>[[SUBSTRING(s,i,j)]]</td></tr>
+<tr><td align='left'>oracle</td><td>No</td><td>[[SUBSTR(s,i,j)]]</td></tr>
 <tr><td align='left'>postgres</td><td>Yes</td><td>[[SUBSTRING(s,i,j)]]</td></tr>
-<tr><td align='left'>sqlserver</td><td>No</td><td>[[SUBSTR(s,i,j)]]</td></tr>
+<tr><td align='left'>sqlserver</td><td>No</td><td>[[SUBSTRING(s,i,j)]]</td></tr>
 </table>
 <h1> SUBSTRING (ansi)</h1>
@@ Line 19: / Line 19: @@
 <source lang='sql' class='def e-oracle e-sqlserver'>
 SELECT name,
-        SUBSTR(name, 2, 5)
+        SUBSTRING(name, 2, 5)
    FROM bbc
 </source>
 <source lang='sql' class='def e-oracle'>
 SELECT name,
-        SUBSTRING(name, 2, 5)
+        SUBSTR(name, 2, 5)
    FROM bbc
 </source>