Help on "decoding" HTML Tags

Connectivity
N/A

Help on "decoding" HTML Tags

Hi there,

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.