SUBSTRING(ansi)

Compatibility

SUBSTRING(s FROM i FOR j)
Engine	OK	Alternative
ingres	Yes	SUBSTRING(s,i,j)
mysql	Yes
oracle	No	SUBSTR(s,i,j)
postgres	Yes	SUBSTRING(s,i,j)
sqlserver	No	SUBSTRING(s,i,j)

SUBSTRING (ansi)

SUBSTRING allows you to extract part of a string.

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

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

See also

• CASE function
• NVL function

Language:Project:Language policy	English  • Deutsch