ÿþset xact_abort on



declare @currval nvarchar(500)

declare @newval nvarchar(500)

declare @search nvarchar(500)

declare @replace varchar(500)



set @search = '' --string to find

set @replace = '' --replacement string



declare @pos int

declare @id bigint



begin tran



declare curs cursor local fast_forward

for

	select mnu_id,item_link

	from menu_to_item_tbl 

	where item_link like '%' + @search +'%'

open curs

fetch next from curs into @id,@currval

while @@fetch_status = 0

begin

	--print 'Url before update=' + @currval

	Set @newval = replace(@currval,@search,@replace)

	

	Update menu_to_item_tbl Set item_link = @newval

	where mnu_id = @id

	

	print 'Value after update=' + @newval



	fetch next from curs into @id, @currval

end



close curs

deallocate curs



--rollback tran

commit tran