LEADING: trim from the beginning of a string
SQL> SQL> -- TRIM 'LEADING' SQL> SQL> SELECT TRIM(LEADING 'S' FROM 'STEVENS' ) AS TRIM FROM Dual; TRIM ------ TEVENS SQL>