Replace trailing digits with zeroes in SQL Server
Increment left most digit with 1 and replace trailing digits with zero
Example 923446 to 1000000
1256 to 2000
0 to 1
Increment left most digit with 1 and replace trailing digits with zero
Example 923446 to 1000000
1256 to 2000
0 to 1