How do you get a portion of a string?

Using SUBSTR you can get a portion of a string.

Example :
SELECT SUBSTR(column_name, 1, 10) from table_name;