CREATE FUNCTION [dbo].[fn_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
Jobs said: There's no reason not to follow your heart.