set xact_abort on

declare @currurl nvarchar(500)
declare @newurl 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 lib_id,[filename]
	from library 
	where [filename] like '%' + @search +'%'
open curs
fetch next from curs into @id,@currurl
while @@fetch_status = 0
begin
	--print 'Url before update=' + @currurl
	Set @newurl = replace(@currurl,@search,@replace)
	
	Update library Set [filename] = @newurl
	where lib_id = @id
	
	print 'Url after update=' + @newurl

	fetch next from curs into @id,@currurl
end

close curs
deallocate curs

--rollback tran
commit tran