substr

Returns the substring of "string_expression" that starts at position "integer_expression1". The first character in "string_expression" is at position 1. "Integer_expression2" can be used to select fewer characters; by default it selects characters to the end of the string.

substr ( string_expression , integer_expression1 [ , 
integer_expression2 ] )