LEFT(first_name,2) AS first_2_letters_from_the_left, RIGHT(first_name,3) AS first_3_letters_from_the_right, SUBSTRING(first_name,2) AS starting_from_the_second_letter ...