update 表名 set 字段名='0701' + right(字段名,len(字段名)-4) where len(字段名)>4
update ta set ID=stuff(ID,1,4,'0701') where left(ID,4)='0506'
update ta set ID=REPLCAE(ID,'0506','0701')
create table tb(id varchar(10)) insert into tb values('0506001') insert into tb values('0506002') insert into tb values('0506003') go update tb set id = '0701' + substring(id,5,len(id)) select * from tb drop table tb/* id ---------- 0701001 0701002 0701003(所影响的行数为 3 行) */
create table tb(id varchar(10)) insert into tb values('0506001') insert into tb values('0506002') insert into tb values('0506003') go update tb set id = replace(id,'0506','0701') select * from tb drop table tb/* id ---------- 0701001 0701002 0701003(所影响的行数为 3 行) */
set ID=stuff(ID,1,4,'???')
set ID=stuff(ID,1,4,'0701')
where left(ID,4)='0506'
set ID=REPLCAE(ID,'0506','0701')
insert into tb values('0506001')
insert into tb values('0506002')
insert into tb values('0506003')
go
update tb
set id = '0701' + substring(id,5,len(id))
select * from tb
drop table tb/*
id
----------
0701001
0701002
0701003(所影响的行数为 3 行)
*/
insert into tb values('0506001')
insert into tb values('0506002')
insert into tb values('0506003')
go
update tb
set id = replace(id,'0506','0701')
select * from tb
drop table tb/*
id
----------
0701001
0701002
0701003(所影响的行数为 3 行)
*/