set xact_abort on
begin tran

declare @currtext nvarchar(255)
declare @newtext nvarchar(255)
declare @search nvarchar(500)
declare @replace varchar(500)
declare @pos int
declare @id bigint
declare @libtype_id int

-- folder names
set @search = '' --string to find
set @replace = '' --replacement string

declare curs cursor local fast_forward
for
	select folder_id,folder_name,libtype_id
	from  library_folder_tbl 
	where folder_name like '%' + @search +'%'
open curs
fetch next from curs into @id,@currtext,@libtype_id
while @@fetch_status = 0
begin
	Set @newtext = replace(@currtext,@search,@replace)
	print 'Changing ' + @currtext + ' to ' + @newtext
	Update library_folder_tbl Set folder_name = @newtext
	where folder_id = @id and libtype_id = @libtype_id
	fetch next from curs into @id,@currtext,@libtype_id
end

close curs
deallocate curs

-- subfolder paths
set @search = '' --string to find
set @replace = '' --replacement string

declare curs cursor local fast_forward
for
	select folder_id,subfolder,libtype_id
	from  library_folder_tbl 
	where subfolder like '%' + @search +'%'
open curs
fetch next from curs into @id,@currtext,@libtype_id
while @@fetch_status = 0
begin
	Set @newtext = replace(@currtext,@search,@replace)
	print 'Changing ' + @currtext + ' to ' + @newtext
	Update library_folder_tbl Set subfolder = @newtext
	where folder_id = @id and libtype_id = @libtype_id
	fetch next from curs into @id,@currtext,@libtype_id
end

close curs
deallocate curs

--rollback tran
commit tran