Difference between revisions of "SUBSTR"

From SQLZOO
Jump to: navigation, search
 
(One intermediate revision by one user not shown)
Line 14: Line 14:
 
<p></p>  
 
<p></p>  
 
<pre style='width:75ex'>
 
<pre style='width:75ex'>
   SUBSTR('Hello world', 2, 3) -> 'llo'     
+
   SUBSTR('Hello world', 2, 3) -> 'ell'     
 
</pre>
 
</pre>
  
 
<div class='ht'>
 
<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'>
 
<source lang='sql' class='def e-sqlserver'>
 
SELECT name,
 
SELECT name,

Latest revision as of 01:16, 25 March 2013

Compatibility
SUBSTR(s, i, j)
EngineOKAlternative
ingresYesSUBSTRING(s FROM i FOR j)
mysqlYesSUBSTRING(s FROM i FOR j)
oracleYes
postgresYesSUBSTRING(s FROM i FOR j)
sqlserverNoSUBSTRING(s,i,j)

SUBSTR

SUBSTR allows you to extract part of a string.

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

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
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense