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

25 votes117 views1 answer
Html add page to document
Html
0 vote115 views1 answer
Fetch('https://www.example.com/index.html') .then(res => res.text()) .then(html => console.log(html));
Html
0 vote121 views1 answer
Userecoilstate vs userecoilvalue
Html
0 vote120 views1 answer
Best slider library
Html
0 vote139 views1 answer
Disable lazyload image smush
Html
-1 vote121 views1 answer
Cellpadding in html
Html
1 vote120 views1 answer
Checkbox switch bootstrap
Html
5 votes122 views1 answer
Html oninput
Html
-1 vote126 views1 answer
How to set image alignment in html
Html
1 vote129 views1 answer
Action_page.php
Html