A customer is searching for a way to efficiently "decode" html tags in a string. This is e.g. to convert an "& Auml;" to an "Ä" or a "& lt;" to a "<". To go over all the strings with a simple replace is not really an option, as there are so many html codes. Does anyone have a UDF or Store Procedure or knows any better way to do this? In the end it should read like:
SELECT decode_html('Three is & lt; five.'); which should return 'Three is < five.' It would also be nice to have this the other way round, so to convert all non-standard signs into html codes &###;. Thanks in advance.