Increment left most digit with 1 and replace trailing digits with zero
Example 923446 to 1000000
1256 to 2000
0 to 1
declare @MyPad1 float = 0;
select cast(trim(str(sum(left(@MyPad1,1)+1))) + replicate(‘0’,len(@MyPad1)-1) as float);
Increment left most digit with 1 and replace trailing digits with zero
Example 923446 to 1000000
1256 to 2000
0 to 1
declare @MyPad1 float = 0;
select cast(trim(str(sum(left(@MyPad1,1)+1))) + replicate(‘0’,len(@MyPad1)-1) as float);