Extracting substrings

Substring: Extracting part of a string.

schema:gisq

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 bbc
 WHERE region = 'Asia'

SELECT name, SUBSTR(name,1,2) FROM bbc

SELECT name, SUBSTRING(name FROM 1 FOR 2)
 FROM bbc
 WHERE region = 'Asia'

SELECT name, MID(name,1,2) FROM bbc
 WHERE region = 'Asia'

SELECT name, SUBSTRING(name FROM 1 FOR 2)
 FROM bbc
 WHERE region = 'Asia'

SELECT name, SUBSTR(name,1,2) FROM bbc

SELECT name, SUBSTRING(name ,1 ,2)
 FROM cia
 WHERE region = 'Asia'

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

SELECT name, SUBSTRING(name FROM 1 FOR 2)
 FROM bbc
 WHERE region = 'Asia'

SELECT name, SUBSTRING(name ,1 ,2)
 FROM bbc
 WHERE region = 'Asia'

Access betrays it's BASIC ancestry. LEFT and RIGHT are also available

See also SUBSTR

SELECT name, SUBSTR(name,1,2)
FROM bbc

WHERE region = 'Asia'

Functions

Concatenate strings

Extracting substrings

lower case

Finding Substring

Formatting numbers

Replace NULL

Conditional values

Time now

Format dates