if exists (select * from sysobjects where id = object_id('dbo.usp_search_replace') and sysstat & 0xf = 4)
	drop procedure dbo.usp_search_replace
GO

CREATE PROCEDURE usp_search_replace
	@tabelnaam varchar(35),
	@kolomnaam varchar(35),
	@zoek varchar(40),
	@vervang varchar(40)
AS

	declare @build varchar(255)
	declare @zoeklengte int

	select @zoeklengte = DATALENGTH(@zoek)
	select @build = "UPDATE " + @tabelnaam + " SET " + @kolomnaam + "= STUFF(" + @kolomnaam + ",PATINDEX('%'+'" + @zoek+"'+'%',"+@kolomnaam+"),"+CONVERT(varchar,@zoeklengte)+",'"+@vervang+"') WHERE PATINDEX('%'+'" + @zoek+"'+'%',"+@kolomnaam+") > 0"
again:
	execute (@build)
	if UPPER(@zoek) <> UPPER(@vervang) AND @@ROWCOUNT > 0 goto again

GO