Monday, August 4, 2014

substring


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