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

0 vote222 views1 answer
Buttosn html
Html
81 votes254 views5 answers
Html5 form
Html
8 votes252 views4 answers
Bootstrap display error message
Html
5 votes186 views1 answer
Connecting metamask to binance smart chain
Html
6 votes173 views1 answer
Timepicker html
Html
-1 vote226 views1 answer
Country list html
Html
255 votes356 views8 answers
Bootstrap 4 cdn
Html
0 vote237 views1 answer
How to send the data through url in html without using the form
Html
34 votes242 views6 answers
Html color text
Html
72 votes231 views3 answers
Flexbox bootstrap 4
Html