怎样容易修改这个解决方法

select stuff('xxxxxxxxd1006',11,2,'0') as new/*newxxxxxxxxd106*/
------解决方案--------------------
SQL code
update tbset col = reverse('d106'+right(reverse(col),len(col)-5))where left(reverse(col),5) = 'd1006'
------解决方案--------------------
SQL code
update tbset 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'