substring

Can you try the below SQL?

   select 
    cast(number as int),substring(number ,1,len(number)-2),cast(substring(number ,1,len(number)-2) as int) from test