Html entity decode in sql query

DECLARE @htmlNames TABLE 
(
    ID INT IDENTITY(1,1), 
    asciiDecimal INT, 
    htmlName varchar(50)
);

INSERT INTO @htmlNames 
VALUES 
    (34,'"'),
    (38,'&'),
    (60,'<'),
    (62,'>'),
    (160,' '),
    (161,'¡'),
    (162,'¢')
;

DECLARE @inputString varchar(max)= '&test&quot;<String>"&';
DECLARE @resultString varchar(max) = @inputString;

-- Simple HTML-decode:
SELECT
    @resultString = Replace(@resultString COLLATE Latin1_General_CS_AS, htmlName, NCHAR(asciiDecimal))
FROM
    @htmlNames
;

SELECT @resultString;
-- Output: &test"<String>"&


-- Multiple HTML-decode:
SET @resultString = @inputString;

DECLARE @temp varchar(max) = '';
WHILE @resultString != @temp
BEGIN
    SET @temp = @resultString;

    SELECT
        @resultString = Replace(@resultString COLLATE Latin1_General_CS_AS, htmlName, NCHAR(asciiDecimal))
    FROM
        @htmlNames
    ;
END;

SELECT @resultString;
-- Output: &test"<String>"&

Source: stackoverflow.com

Similar codes

6 votes214 views3 answers
Ion-select placeholder
Html
1 vote199 views1 answer
What is spread in trading
Html
5 votes207 views9 answers
Sweetalert
Html
-2 votes213 views1 answer
Post request html android
Html
0 vote287 views1 answer
Swiper slider responsive
Html
0 vote309 views1 answer
Prevent from going to a function html click
Html
14 votes208 views2 answers
Add a viewport meta tag to the document head to set the width of the layout viewport equal to the width of the device and set the initial scale of the viewport to 1.0.
Html
0 vote208 views1 answer
Html how to move a image
Html
0 vote208 views1 answer
2 button component in single row vuetify
Html
0 vote240 views1 answer
Fontawesome online link
Html