CODE EXAMPLE FOR SQL

ORACLE SUBSTRING SYNTAX

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