• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 480
  • Last Modified:

removing HTML tags in SQL Server 2005 or 2008

HI, I have few records in my table in the below format.


Does the operator wish to apply for the <a href="../public/glossary.htm#TEST" target="_new" id="_glossary">TEST</a> scheme?


I need the above record to appear as  below -

Does the operator wish to apply for the TEST scheme?

Can anyone  give me the TSQL Code to remove this html code
as I just need to get the text part of it.

Many Thanks
0
gvamsimba
Asked:
gvamsimba
2 Solutions
 
arnoldCommented:
http://www.codeproject.com/KB/string/SqlRegEx.aspx

Alternatively, using/setting up an ASP/ASP.Net page that will query the table/field strip out the HTML and update the entry.

If you have perl on your system you might be able to use it to do the same task.

0
 
MeLindaJohnsonCommented:
select replace(replace(FIELDNAME,'<a href="../public/glossary.htm#TEST" target="_new" id="_glossary">',''),'</a>','') from TABLENAME
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now