SQLzoo.net

Substring: Extracting part of a string.


We from position 1 (the beginning) we take two characters. 4. 'Afghanistan' -> 'Af' 'China' -> 'Ch' 'Sri Lanka' -> 'Sr' The SQL standard insists on a horrible syntax: SUBSTRING(name FROM 1 FOR 2)	SELECT name, SUBSTRING(name FROM 1 FOR 2) FROM cia WHERE region = 'Asia'
Specific to
none