i played with something similar, where i was converting from xml/html entities to the unicode? character char definition.
the problem was i was using a recursive function, and the #of recursion levels is limited to 100, but of course there are more html entities than that that are defined.
because of limitations in the forum, you cannot paste html entities; they get displayed instead, which makes pasting code pointless for issues like this.
take a look at this Inline Table Valued Function i played with a while ago; it does most of what you want.XML_To_ASCII.txt
(note the array of possible values in the function is the complete list...to get it to work, you need to remove/comment out some of the values so there are only 100 items to replace--much easier to edit and comment out than try to add in something that was missing but you need.)
thinking about it deeper, i think the right thing to do would be to create two or more functions, so each one can do 100 find/replaces, until the whole possible collection of html entities are replaced.
here's a list of all the entities for refernece:http://www.w3schools.com/tags/ref_entities.asp
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!