SQL Server: UDF to remove HTML Tag from the String Data

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

In this post, I have created one user defined function to remove all HTML tags from the string data of SQL Server.

There are certain requirements like, store HTML document into the text column, but unfortunately it also contains HTML tags which required to remove.

I have found one user defined function to remove all HTML Tags from the given string.

CREATE FUNCTION dbo.RemoveHTML (@HTMLData VARCHAR(MAX))

RETURNS VARCHAR(MAX) AS

BEGIN

DECLARE @HTMLDataXML XML

DECLARE @ResultData VARCHAR(MAX)

SET @HTMLDataXML = REPLACE( @HTMLData, '&', '' );

WITH HTMLDoc(texts) AS

(

SELECT chunks.chunk.query('.') FROM @HTMLDataXML.nodes('/') AS chunks(chunk)

)

SELECT @ResultData = texts.value('.', 'varchar(max)') FROM HTMLDoc

RETURN @ResultData

END

Sample Execution:

1	SELECT dbo.RemoveHTML(' This is a Database Research and Development ')

Sep 26, 2016Anvesh Patel

Comments: 2

Elayaraja A

November 26, 2018 at 10:01 am

Thanks a Lot Dear…

Dhanashri Kondap

May 3, 2019 at 5:57 pm

Hi,
I am trying to use this function to remove html tags and getting error
declare @desc as nvarchar(4000) = ‘Active Building is the new standard resident portal offering for properties operating on the RealPage platform.
ActiveBuilding is an advanced community portal intended to provide communities with more avenues for engagement with residents.
Active Building offers a messaging service that can send individual or mass messages to residents via texts, phone calls, emails or social media platforms.
It also offers an interactive online community to drive engagement within the community and the connectedness of onsite team members and residents.
Residents can created, their own profiles with specific interests; swap news, plan events, schedule play dates and send messages.
A private community social space is intended to increase resident retention and bolster the property’s reputation.
In addition to the social community, standard resident portal functionality, like online rent payments and service requests,
Active Building also provides opportunities to highlight local neighborhood vendors. ‘
select dbo.RemoveHTML(@desc)

SQL Server: UDF to remove HTML Tag from the String Data

Anvesh Patel

About Me!

About DBRND !

Recent Comments !

Follow Me !