Browse by Tags

All Tags » clean data (RSS)
02 December 2009 13:58

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...
Posted by Madhivanan | 2 comment(s)
Filed under: , ,
12 October 2009 14:28

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...
Posted by Madhivanan | 2 comment(s)
Filed under: , , ,
11 May 2009 13:49

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...
Posted by Madhivanan | 2 comment(s)
Filed under: , ,