Sql function to replace in HTML text without affecting HTML structure

When we have a requirement to replace text within HTML content that is stored in DB column, if we use the sql inbuilt function "Replace" then there are chances to mess up the HTML tags and their attributes. This post shows how to write a sql function to replace text in HTML content without affecting the HTML elements and attributes. This function just replaces the text within HTML content and keeps the HTML structure as it is.