• I refactored the function that I found at the following URL... look for the answer posted by "dudeNumber4"...

    CREATE FUNCTION dbo.StripHtmlTags

    (@HtmlText XML )

    RETURNS NVARCHAR(MAX)

    AS

    BEGIN

    RETURN (

    SELECT contents.value('.', 'nvarchar(max)')

    FROM (

    SELECT contents = chunks.chunk.query('.') FROM @HtmlText.nodes('/') AS chunks(chunk)

    ) doc

    )

    END

    ;

    I tried turning it into an iTVF instead of a scalar function and it took twice as long to run.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)