Showing posts with label tsql. Show all posts
Showing posts with label tsql. Show all posts

10/31/14

SQL Server Parse HTML Content from Data

With this TSQL script, we can remove HTML content as long as there are valid start and ending HTML tags. Script: Create FUNCTION [dbo].[udf_StripHTMLContent] (@content VARCHAR(MAX),@tagStart varchar(55),  @tagEnd varchar(55)) RETURNS VARCHAR(MAX) AS BEGIN DECLARE @start INT=1 DECLARE @end INT=1 DECLARE @len INT=1            ...