Introduction:
Here I will explain how to remove html tags from string in SQL Server or how to parse html tags and retrieve only text from string in SQL Server without using regular expressions or remove text between < and > and get only text from string in SQL Server.
Here I will explain how to remove html tags from string in SQL Server or how to parse html tags and retrieve only text from string in SQL Server without using regular expressions or remove text between < and > and get only text from string in SQL Server.
Description:
In
previous articles I written Can function return multiple values in SQL Server, SQL Server split function to split string with comma, SQL query to get data between two
characters range, SQL Server reset identity column to 1
in database,
SQL Server acid properties and many articles
related to SQL
Server.
Now I will explain how to remove html tags from string in SQL
Server.
To
implement this functionality we need to create one user defined function to
parse html text and return only text