I've got data in SQL Server 2005 that contains HTML tags and I'd like to strip all that out, leaving just the text between the tags. Ideally also replacing things like < with <, etc.
Is there an easy way to do this or has someone already got some sample t-SQL code?
I don't have the ability to add extended stored procs and the like, so I would prefer a pure t-SQL approach (preferably one backward compatible with SQL 2000).
I just want to retrieve the data with stripped out HTML, not update it, so ideally it would be written as a user-defined function, to make for easy reuse.
So, for example, converting this:
<B>Some useful text</B>
<A onclick="return openInfo(this)"
<IMG title="Source Description" height=15 alt="Source Description"
src="/ri/new_info.gif" width=15 align=top border=0>
</A>> <b>more text</b></TD></TR>
Some useful text > more text