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

12 votes98 views3 answers
How to make text bigger in html
Html
15 votes123 views6 answers
Html title attribute
Html
19 votes102 views5 answers
Vue if class
Html
0 vote110 views1 answer
Html.getenumselectlist
Html
0 vote105 views1 answer
Remark asp markup
Html
0 vote103 views1 answer
Html sup tag
Html
0 vote114 views1 answer
H vhjf
Html
3 votes95 views2 answers
Html email input
Html
1 vote139 views3 answers
Email button html
Html
9 votes106 views2 answers
Html input tag
Html