declare @t table([date] varchar(10)) insert into @t select '2005-2/3' union all select '2005-2/1' union all select '2005-2/2'update @t set [date]=replace([date],'2005','2006') select * from @t
update news set [path]=replace([path],'2005','2006')
update news set path=replace(path,'2005','2006') where charindex('2005',path)>0
update tb set pathreplace(path'2005','2006')
update tb set path=replace(path'2005','2006')
update news set [path]=replace([path],'2005','2006')
insert into @t select '2005-2/3'
union all select '2005-2/1'
union all select '2005-2/2'update @t set [date]=replace([date],'2005','2006')
select * from @t
set path=replace(path,'2005','2006')
where charindex('2005',path)>0
set pathreplace(path'2005','2006')
set path=replace(path'2005','2006')