SELECT LEFT(cus.FirstName, 2)
FROM Customer cus

/*Results*/
----
Pa
Pe
Ma
Mi
Vi
[...]

----------

SELECT RIGHT(cus.FirstName, 2)
FROM Customer cus

/*Results*/
----
lo
ro
ia
el
ia

----------

SELECT LTRIM(' Removes trailing spaces.')

/*Results*/
-------------------------
Removes trailing spaces.

----------

SELECT RTRIM('Removes trailing spaces. ')

/*Results*/
-------------------------
Removes trailing spaces.

----------

SELECT SUBSTRING(cus.FirstName, 2, 3)
FROM Customer cus

/*Results*/
----
aol
edr
ari
igu
ict
[...]