SUBSTR

Use SUBSTR to return a substring of a string. The first parameter is the string expression. The second parameter is starting position for the substring. The third parameter is the number of characters for the substring. The third parameter is optional.

SUBSTR(string_expression, start_position, number_of_characters)

SELECT SUBSTR('baseball team', 10)