Replace String

[jayfox]

I have a text field with html tags in it and I want to get rid of them. I would like to replace everything between'<' and '>'. There will be more than one occurance od this in the field.
Please help.

 

[dbomrrsm]

so if the field contains '123<some text>456' you want to remove all between the < and > to leave '123<>456' or leave '123456' or do you just want to remove the < and > to leave '123some text456'

If it is the latter do you want spaces where the < and > where ?

DBomrrsm

 

[jayfox]

I would like also to remove < and >

 

[dbomrrsm]

SELECT REPLACE(MYField,'<',' ')
Go
SELECT REPLACE(MYField,'>',' ')
Go

DBomrrsm

 

[vongrunt]

You want to strip out HTML tags... maybe it isn't good idea to do it in database but anyway - try this:

create function strip_tags( @s varchar(4000) )
returns varchar(4000) as
begin
	declare @pos1 smallint, @pos2 smallint
	set @pos2 = 1

	while @pos2  > 0
	begin
		set @pos1 = charindex('<', @s, @pos2)
		set @pos2 = charindex('>', @s, @pos1+1)
		if @pos1 = 0 or @pos2 = 0 break

		set @s = left(@s, @pos1-1) + right(@s, len(@s)-@pos2)
		set @pos2 = @pos2-2
	end

	return @s
end

Bugs included, comments welcomed :X

 

[jayfox]

Just looking at this it will not remove the text in between < and >.