替换(stuff)

begin tran
declare @ppt_part varchar(15)
declare @ppt_desc1 varchar(35)
declare @len_1 int
declare @len_2 int
declare @len_3  int
--declare @into varchar(10)

declare cur_1 cursor local static scroll for
select pt_part,pt_desc1 from cp_mstr
join pt_mstr on pt_part = cp_part
where cp_cust = 'E20301' and pt_status ='1' and len(pt_part)> '10'

open cur_1
fetch first from cur_1 into
@ppt_part,@ppt_desc1
while @@fetch_status = 0
begin
set @len_1 = (select charindex('/',@ppt_desc1))
set @len_2 = (select charindex('/',@ppt_desc1,@len_1+2))
set @len_3 = @len_2 - @len_1

update pt_mstr
set pt_desc1 = stuff(@ppt_desc1,@len_1+1,@len_3-1,'SIM-福永')
where pt_part = @ppt_part

update gcerp35_00..part_com
set part_desc1 = (select pt_desc1 from pt_mstr where pt_part = @ppt_part)
where part_part = @ppt_part

fetch next from cur_1 into @ppt_part,@ppt_desc1
end
close cur_1
deallocate cur_1

select rtrim(pt_part),rtrim(pt_desc1) from cp_mstr
join pt_mstr on pt_part = cp_part
where cp_cust = 'E20301' and pt_status ='1' and len(pt_part)> '10'

select rtrim(part_part),rtrim(part_desc1) from gcerp35_00..part_com
where part_part like '90203%' and len(part_part) >'10'

rollback