Revision as of 11:02, 28 October 2012

SUBSTRING (ansi)

SUBSTRING allows you to extract part of a string.

   SUBSTRING('Hello world' FROM 2 FOR 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

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

@@ Line 18: / 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-oracle e-sqlserver'>
 SELECT name,