Remove html tag while inserting email column in SQL

Hi ps222,

Please refer the below code to remove the html tag.But if you are facing sql injuction then better to use stored procedure for inserting the record to database in stade of inline code.

SQL

CREATE FUNCTION RemoveHtmlTags
(
	@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

SELECT dbo.RemoveHtmlTags('admin@gmail.com<strong>ggr</strong><div>resoursec<a>linkk</a></div>') AS EMAIL

Screenshot