substring

Try the latest SQL

    select 
    number,
    case when cast(substring(number ,len(number)-1,len(number)) as int)in( 00,01,02,03,04,05,06,07,08,09)
    then cast(substring(number ,1,len(number)-2) as int) else 
     cast(number  as int)  end
 from test

Output->

057740500 577405

0410104 4101

087219602 872196

0020190 20190

0077853 77853

--Prashanth