http://sqlzoo.net/w/index.php?title=SUBSTRING(ansi)&feed=atom&action=history SUBSTRING(ansi) - Revision history 2013-05-21T20:24:37Z Revision history for this page on the wiki MediaWiki 1.20.4 http://sqlzoo.net/w/index.php?title=SUBSTRING(ansi)&diff=10948&oldid=prev Andr3w at 09:28, 24 March 2013 2013-03-24T09:28:56Z <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 09:28, 24 March 2013</td> </tr><tr><td colspan="2" class="diff-lineno">Line 14:</td> <td colspan="2" class="diff-lineno">Line 14:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;p&gt;&lt;/p&gt; &#160;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;p&gt;&lt;/p&gt; &#160;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;pre style='width:75ex'&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;pre style='width:75ex'&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&#160;&#160; SUBSTRING('Hello world' FROM 2 FOR 3) -&gt; '<del class="diffchange diffchange-inline">llo</del>'&#160; &#160; &#160;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&#160;&#160; SUBSTRING('Hello world' FROM 2 FOR 3) -&gt; '<ins class="diffchange diffchange-inline">ell</ins>'&#160; &#160; &#160;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/pre&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/pre&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> </table> Andr3w http://sqlzoo.net/w/index.php?title=SUBSTRING(ansi)&diff=4346&oldid=prev Peter at 11:02, 28 October 2012 2012-10-28T11:02:28Z <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 11:02, 28 October 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 18:</td> <td colspan="2" class="diff-lineno">Line 18:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;div class='ht'&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;div class='ht'&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>In this example you <del class="diffchange diffchange-inline">put </del>the <del class="diffchange diffchange-inline">region and the name together for </del>each country. <del class="diffchange diffchange-inline"> </del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>In this example you <ins class="diffchange diffchange-inline">get </ins>the <ins class="diffchange diffchange-inline">2nd to 5th character from </ins>each country<ins class="diffchange diffchange-inline">'s name</ins>. <ins class="diffchange diffchange-inline">&#160; </ins></div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang='sql' class='def e-oracle e-sqlserver'&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang='sql' class='def e-oracle e-sqlserver'&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name,</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name,</div></td></tr> </table> Peter http://sqlzoo.net/w/index.php?title=SUBSTRING(ansi)&diff=4343&oldid=prev Peter at 10:59, 28 October 2012 2012-10-28T10:59:40Z <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:59, 28 October 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 4:</td> <td colspan="2" class="diff-lineno">Line 4:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='center'&gt;'''Engine'''&lt;/td&gt;&lt;td align='center'&gt;'''OK'''&lt;/td&gt;&lt;td align='center'&gt;'''Alternative'''&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='center'&gt;'''Engine'''&lt;/td&gt;&lt;td align='center'&gt;'''OK'''&lt;/td&gt;&lt;td align='center'&gt;'''Alternative'''&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;ingres&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[SUBSTRING |SUBSTRING(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;ingres&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[SUBSTRING |SUBSTRING(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td colspan="2">&#160;</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;">&lt;tr&gt;&lt;td align='left'&gt;mysql&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;</ins></div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;oracle&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[SUBSTR |SUBSTR(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;oracle&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[SUBSTR |SUBSTR(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;postgres&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[SUBSTRING |SUBSTRING(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;postgres&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[SUBSTRING |SUBSTRING(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> </table> Peter http://sqlzoo.net/w/index.php?title=SUBSTRING(ansi)&diff=4340&oldid=prev Peter at 10:52, 28 October 2012 2012-10-28T10:52:58Z <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:52, 28 October 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 8:</td> <td colspan="2" class="diff-lineno">Line 8:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;sqlserver&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[SUBSTRING |SUBSTRING(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;sqlserver&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[SUBSTRING |SUBSTRING(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td></tr> <tr><td colspan="2">&#160;</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 class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;h1&gt; SUBSTRING (ansi)&lt;/h1&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;h1&gt; SUBSTRING (ansi)&lt;/h1&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;p&gt;SUBSTRING allows you to extract part of a string. &lt;/p&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;p&gt;SUBSTRING allows you to extract part of a string. &lt;/p&gt;</div></td></tr> <tr><td colspan="2" class="diff-lineno">Line 39:</td> <td colspan="2" class="diff-lineno">Line 40:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[NVL |NVL function]]&lt;/li&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[NVL |NVL function]]&lt;/li&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/ul&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/ul&gt;</div></td></tr> <tr><td colspan="2">&#160;</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">&#160;</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://sqlzoo.net/w/index.php?title=SUBSTRING(ansi)&diff=1398&oldid=prev Connor at 15:26, 16 July 2012 2012-07-16T15:26:30Z <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 15:26, 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'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;th colspan='3'&gt;SUBSTRING(s FROM i FOR j)&lt;/th&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;th colspan='3'&gt;SUBSTRING(s FROM i FOR j)&lt;/th&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='center'&gt;'''Engine'''&lt;/td&gt;&lt;td align='center'&gt;'''OK'''&lt;/td&gt;&lt;td align='center'&gt;'''Alternative'''&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='center'&gt;'''Engine'''&lt;/td&gt;&lt;td align='center'&gt;'''OK'''&lt;/td&gt;&lt;td align='center'&gt;'''Alternative'''&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;ingres&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[SUBSTRING(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;ingres&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[<ins class="diffchange diffchange-inline">SUBSTRING |</ins>SUBSTRING(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;oracle&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[SUBSTR(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;oracle&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[<ins class="diffchange diffchange-inline">SUBSTR |</ins>SUBSTR(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;postgres&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[SUBSTRING(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;postgres&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[<ins class="diffchange diffchange-inline">SUBSTRING |</ins>SUBSTRING(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;sqlserver&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[SUBSTRING(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;sqlserver&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[<ins class="diffchange diffchange-inline">SUBSTRING |</ins>SUBSTRING(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;h1&gt; SUBSTRING (ansi)&lt;/h1&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;h1&gt; SUBSTRING (ansi)&lt;/h1&gt;</div></td></tr> </table> Connor http://sqlzoo.net/w/index.php?title=SUBSTRING(ansi)&diff=1337&oldid=prev Connor at 14:15, 16 July 2012 2012-07-16T14:15:19Z <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:15, 16 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 4:</td> <td colspan="2" class="diff-lineno">Line 4:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='center'&gt;'''Engine'''&lt;/td&gt;&lt;td align='center'&gt;'''OK'''&lt;/td&gt;&lt;td align='center'&gt;'''Alternative'''&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='center'&gt;'''Engine'''&lt;/td&gt;&lt;td align='center'&gt;'''OK'''&lt;/td&gt;&lt;td align='center'&gt;'''Alternative'''&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;ingres&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[SUBSTRING(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;ingres&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[SUBSTRING(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;oracle&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[<del class="diffchange diffchange-inline">SUBSTRING</del>(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;oracle&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[<ins class="diffchange diffchange-inline">SUBSTR</ins>(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;postgres&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[SUBSTRING(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;postgres&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[SUBSTRING(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;sqlserver&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[<del class="diffchange diffchange-inline">SUBSTR</del>(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;sqlserver&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[<ins class="diffchange diffchange-inline">SUBSTRING</ins>(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;h1&gt; SUBSTRING (ansi)&lt;/h1&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;h1&gt; SUBSTRING (ansi)&lt;/h1&gt;</div></td></tr> <tr><td colspan="2" class="diff-lineno">Line 19:</td> <td colspan="2" class="diff-lineno">Line 19:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang='sql' class='def e-oracle e-sqlserver'&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang='sql' class='def e-oracle e-sqlserver'&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name,</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name,</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&#160;&#160; &#160; &#160; <del class="diffchange diffchange-inline">SUBSTR</del>(name, 2, 5)</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&#160;&#160; &#160; &#160; <ins class="diffchange diffchange-inline">SUBSTRING</ins>(name, 2, 5)</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; FROM bbc</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; FROM bbc</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/source&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/source&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang='sql' class='def e-oracle'&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang='sql' class='def e-oracle'&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name,</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name,</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&#160;&#160; &#160; &#160; <del class="diffchange diffchange-inline">SUBSTRING</del>(name, 2, 5)</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&#160;&#160; &#160; &#160; <ins class="diffchange diffchange-inline">SUBSTR</ins>(name, 2, 5)</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; FROM bbc</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; FROM bbc</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/source&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/source&gt;</div></td></tr> </table> Connor http://sqlzoo.net/w/index.php?title=SUBSTRING(ansi)&diff=1336&oldid=prev Connor: Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>SUBSTRING(s FROM i FOR j)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='ce..." 2012-07-16T14:10:33Z <p>Created page with &quot;&lt;table align=&#039;right&#039; border=&#039;1&#039;&gt; &lt;caption&gt;Compatibility&lt;/caption&gt; &lt;tr&gt;&lt;th colspan=&#039;3&#039;&gt;SUBSTRING(s FROM i FOR j)&lt;/th&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td align=&#039;center&#039;&gt;&#039;&#039;&#039;Engine&#039;&#039;&#039;&lt;/td&gt;&lt;td align=&#039;ce...&quot;</p> <p><b>New page</b></p><div>&lt;table align='right' border='1'&gt;<br /> &lt;caption&gt;Compatibility&lt;/caption&gt;<br /> &lt;tr&gt;&lt;th colspan='3'&gt;SUBSTRING(s FROM i FOR j)&lt;/th&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='center'&gt;'''Engine'''&lt;/td&gt;&lt;td align='center'&gt;'''OK'''&lt;/td&gt;&lt;td align='center'&gt;'''Alternative'''&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;ingres&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[SUBSTRING(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;oracle&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[SUBSTRING(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;postgres&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[SUBSTRING(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;sqlserver&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[SUBSTR(s,i,j)]]&lt;/td&gt;&lt;/tr&gt;<br /> &lt;/table&gt;<br /> &lt;h1&gt; SUBSTRING (ansi)&lt;/h1&gt;<br /> &lt;p&gt;SUBSTRING allows you to extract part of a string. &lt;/p&gt;<br /> &lt;p&gt;&lt;/p&gt; <br /> &lt;pre style='width:75ex'&gt;<br /> SUBSTRING('Hello world' FROM 2 FOR 3) -&gt; 'llo' <br /> &lt;/pre&gt;<br /> <br /> &lt;div class='ht'&gt;<br /> In this example you put the region and the name together for each country. <br /> &lt;source lang='sql' class='def e-oracle e-sqlserver'&gt;<br /> SELECT name,<br /> SUBSTR(name, 2, 5)<br /> FROM bbc<br /> &lt;/source&gt;<br /> &lt;source lang='sql' class='def e-oracle'&gt;<br /> SELECT name,<br /> SUBSTRING(name, 2, 5)<br /> FROM bbc<br /> &lt;/source&gt;<br /> &lt;source lang='sql' class='def'&gt;<br /> SELECT name,<br /> SUBSTRING(name FROM 2 FOR 5)<br /> FROM bbc<br /> &lt;/source&gt;<br /> &lt;/div&gt;<br /> <br /> &lt;p&gt;See also&lt;/p&gt;<br /> &lt;ul&gt;<br /> &lt;li&gt;[[CASE |CASE function]]&lt;/li&gt;<br /> &lt;li&gt;[[NVL |NVL function]]&lt;/li&gt;<br /> &lt;/ul&gt;</div> Connor