SUBSTR(FIRST_NAME,2), --if you didnt specify the n value, then it will be to the end of string SUBSTR(FIRST_NAME,-3)--if m is negative , then the count start from the end SELECT TRIM (' ' FROM ' ...