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.