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 vote165 views1 answer
How do I change the default text in dropzone.js?
Html
0 vote249 views1 answer
How to select value in ul li tag in html
Html
0 vote216 views1 answer
Elasticsearch built-in security features are not enabled. Without authentication, your cluster could be accessible to anyone. See https://www.elastic.co/guide/en/elasticsearch/reference/7.15/security-minimal-setup.html to enable security.
Html
1 vote176 views1 answer
Div right and left
Html
0 vote161 views1 answer
Roboto font embed
Html
0 vote183 views2 answers
How to increase size of input submit type in html
Html
5 votes169 views2 answers
Sessionnotcreatedexception: message: session not created: this version of chromedriver only supports chrome version 81
Html
0 vote169 views1 answer
Html maintain text in one line
Html
0 vote166 views1 answer
Center class in html
Html
1 vote185 views2 answers
Html body full height
Html