CODE EXAMPLE FOR SQL

substr sql last character

SELECT RIGHT( '1234567890', 4 ); -- returns '7890'
SELECT SUBSTR( _col_NAME_, LENGTH(_col_NAME_)-3, 4 ); -- string indexing starts from 1