I'm not sure if this is possible but i'm trying to read a text field into a temporary table and get rid of all html tags in it.
select substring(descriprion,1,200) into #temp from myTable
I want to get rid of html tags that might exist in that column. the problem is I can not simply use Replace() and have it hardcoded since it may contain different HTML (e.g. <font color=red size=20> my description </font>)
I'm pretty much lookin for suggestions to achieve this
Thanks in advance