select stuff('xxxxxxxxd1006',11,2,'0') as new
/*
new
xxxxxxxxd106
*/

------解决方案--------------------
SQL code

update tb
set col = reverse('d106'+right(reverse(col),len(col)-5))
where left(reverse(col),5) = 'd1006'

------解决方案--------------------
SQL code
update tb
set col =stuff('xxxxxxxxd1006',11,2,'0')
where col  like  '%d1006'

------解决方案--------------------
探讨

SQL code


update tb
set col = reverse('d106'+right(reverse(col),len(col)-5))
where left(reverse(col),5) = 'd1006'