SUBSTRING (ansi)

SUBSTRING allows you to extract part of a string.

 SUBSTRING('Hello world' FROM 2 FOR 3) -> 'llo' 

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

• CASE statement
• NVL function