Difference between revisions of "SUBSTR"
From SQLZOO
(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...") |
|||
| Line 17: | Line 17: | ||
<div class='ht'> | <div class='ht'> | ||
In this example you put the region and the name together for each country. | In this example you put the region and the name together for each country. | ||
| − | <source lang='sql' class='def | + | <source lang='sql' class='def e-sqlserver'> |
SELECT name, | SELECT name, | ||
SUBSTRING(name, 2, 5) | SUBSTRING(name, 2, 5) | ||
Revision as of 15:25, 16 July 2012
| SUBSTRING(s FROM i FOR j) | ||
|---|---|---|
| Engine | OK | Alternative |
| ingres | Yes | SUBSTRING(s FROM i FOR j) |
| oracle | Yes | |
| postgres | Yes | SUBSTRING(s FROM i FOR j) |
| sqlserver | No | SUBSTRING(s,i,j) |
SUBSTR
SUBSTR allows you to extract part of a string.
SUBSTR('Hello world', 2, 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
