CODE EXAMPLE FOR SQL

oracle sql two left digits

-- ORACLE SQL - Get the 2 digits at the LEFT end of a string
SELECT SUBSTR('TN0001234567890345',1,2) FROM DUAL;