Browse by Tags

Removing unwanted characters - Part 2

In my previous post about Removing unwanted characters , I posted a method that used a function Here is another method that uses Dynamic SQL declare @data table ( data varchar ( 100 )) -- table that has source data insert @data select 'tes^@&t %stri)-n!g' data union all select '))aaer...

Posted to Madhivanan (Weblog) by Madhivanan on Wed, Dec 2 2009
Removing tags from a string

In http://ask.sqlteam.com , a question was asked about removing the comments from the HTML template The comments have the following pattern {/*}comment{*/} The comments can be nested too The task is to remove all the comments Here is my solution declare @string varchar ( 8000 ) , @data varchar ( 8000...

Posted to Madhivanan (Weblog) by Madhivanan on Mon, Oct 12 2009
Removing unwanted characters

Sometimes when you import data from other system , you may want to clean up data by removing unwanted characters You can use Replace function . Suppose you want to remove the character ^ from the string declare @str varchar ( 100 ) set @str = 'test^ string' select @str = replace ( @str , '...

Posted to Madhivanan (Weblog) by Madhivanan on Mon, May 11 2009

Page 1 of 1 (3 items)

SQL Server Blogs