select number
,Cast(substring(number, 1,len(number)-2)+ cast(Case WHEN cast(right(number,2) as int)>9 Then cast(Cast(right(number,2)as int) as varchar(2)) Else '' ENd as varchar(2)) as int) as number
from test
/*
number number
057740500 577405
0410104 4101
087219602 872196
0020190 20190
0077853 77853
*/
No comments:
Post a Comment