Find and replace/wrap certain terms in html tags
SQL Server is not the best with String Manipulation.  If this functionality will change over time or become complex in any nature, I would suggest you look into CLR as a way to search/replace complex strings.  Here's a great article from Phil Factor on Simple Talk that walks through how to use CLR for complex string operations.