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 votes126 views2 answers
Read only attribute in html
Html
0 vote146 views1 answer
Sanity api call html
Html
253 votes319 views10 answers
Bootstrap cdn
Html
3 votes154 views2 answers
Html prevent newline
Html
0 vote155 views1 answer
Html auto start video
Html
30 votes139 views2 answers
Html space between characters
Html
0 vote136 views1 answer
Edit text on click html5
Html
0 vote133 views1 answer
Link to add matrial iocns to html
Html
-1 vote136 views2 answers
How to shift div to right
Html
39 votes168 views6 answers
Href mailto
Html