create table ai (id nvarchar(100)) insert into ai values('1001009999') insert into ai values('1001008888') select * from aiupdate ai set id ='101000'+right(id,len(id)-6) select * from ai
update tablename set id =REPLACE(id,SUBSTRING(id,1,6),'101000')
update tablename set id =REPLACE(id,SUBSTRING(id,1,6),'101000')
set id =replace(id,'100100','101000')
id='101000' + right(id,len(id)-6)
set id ='101000' + right(id,len(id)-6))
insert into ai values('1001009999')
insert into ai values('1001008888')
select * from aiupdate ai
set id ='101000'+right(id,len(id)-6)
select * from ai
set id =REPLACE(id,SUBSTRING(id,1,6),'101000')
set id =REPLACE(id,SUBSTRING(id,1,6),'101000')