Technical Article

Recursive Replace Function

,

User Defined Function that recursively replaces string1 from string2

Create Function ReplaceRecursive
(@Input varchar(8000), @Find varchar(100), @Replace varchar(100))
RETURNS varchar(8000)
BEGIN	
	Declare @Output 	varchar(8000)
	Declare @Counter 	int
	
	Set	@Output = @Input
	Set	@Counter = 1

	While 	@Counter <= Len(@Output)
	Begin
		Set @Output  = Replace(@Output, @Find, @Replace)
	        Set @Counter = @Counter + 1
	End
	
	
	Return	@Output
END

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

Share

Tags

Join the discussion and add your comment

Share

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

Related content

SQLServerCentral Article

A Normalization Primer

For most DBAs, normalization is an understood concept, a bread and butter bit of knowledge. However, it is not at all unusual to review a database design by a development group for an OLTP (OnLine Transaction Processing) environment and find that the schema chosen is anything but properly normalized. This article by Brian Kelley will give you the core knowledge to data model.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (3)

You rated this post out of 5. Change rating

2003-01-13

18,069 reads