Eine Einführung in
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)
|Specific to MS Access|
|Access betrays it's BASIC ancestry. LEFT and RIGHT are also available|