Remove html from string in sql

CREATE FUNCTION [dbo].[udf_StripHTML] (@HTMLText VARCHAR(MAX))
RETURNS VARCHAR(MAX) AS
BEGIN
    DECLARE @Start INT
    DECLARE @End INT
    DECLARE @Length INT
    SET @Start = CHARINDEX('<',@HTMLText)
    SET @End = CHARINDEX('>',@HTMLText,CHARINDEX('<',@HTMLText))
    SET @Length = (@End - @Start) + 1
    WHILE @Start > 0 AND @End > 0 AND @Length > 0
    BEGIN
        SET @HTMLText = STUFF(@HTMLText,@Start,@Length,'')
        SET @Start = CHARINDEX('<',@HTMLText)
        SET @End = CHARINDEX('>',@HTMLText,CHARINDEX('<',@HTMLText))
        SET @Length = (@End - @Start) + 1
    END
    RETURN LTRIM(RTRIM(@HTMLText))
END
GO

Source: stackoverflow.com

Similar codes

5 votes170 views9 answers
Sweetalert
Html
1 vote191 views1 answer
Void javascript link
Html
1 vote162 views1 answer
Nuxt cursor focus
Html
4 votes182 views1 answer
Input acepta solo imagnes
Html
0 vote169 views1 answer
How to add quantity button in html
Html
202 votes245 views6 answers
Href open in new tab
Html
1 vote180 views1 answer
Bootstrap upload image plugin for html
Html
0 vote172 views1 answer
How to make a search engine in html
Html
-2 votes156 views2 answers
How to highlight any text in html and css
Html
1 vote169 views1 answer
A line in the middle of atom editor
Html