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 vote184 views1 answer
Https://www.xnxx.com/video-rt4pdd3/lovely_latina_girlfriend_on_a_big_fat_dick
Html
9 votes165 views2 answers
Get svg code from uploaded svg file
Html
0 vote132 views1 answer
@endguest
Html
4 votes179 views1 answer
Code hightlighting html
Html
0 vote164 views2 answers
Auto select radio button
Html
-1 vote171 views1 answer
Html imput button
Html
0 vote175 views1 answer
Automatically closed menu after clicked event
Html
2 votes187 views5 answers
InnerHTML is not a function
Html
0 vote187 views2 answers
How to set an svg favicon in html
Html
27 votes159 views3 answers
Html code editor
Html