substring

try this :

DECLARE @T TABLE (v vARCHAR(20))
INSERT INTO @T 
SELECT '057740500' -------> 577405
UNION ALL
SELECT '0410104' --------> 4101
UNION ALL
SELECT '087219602' ----> 872196
UNION ALL
SELECT '0020190' ------> 20190
UNION ALL
SELECT '0077853' -------> 77853


SELECT * 
FROM @T T
CROSS APPLY 
(
        VALUES ('00'),('01'),('02'),('03'),('04'),('05'),('06'),('07'),('08'),('09')
)TVC(val)
WHERE RIGHT(SUBSTRING(v, PATINDEX('%[1-9]%',v) , LEN(v)),2) = TVC.val

---

Thanks and regards, Rishabh K