InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 02:10:20 GMT20http://www.sqlservercentral.com/Forums/Topic1058310-392-1.aspxThe column in this you care about is 'Final Removal'.I broke it down so you can see what each component of the function is doing.Please test and confirm this will work for you. Notice I work backwards through the string so I don't have to constantly repeat previous work (like removing the anchor tag).[code="sql"]IF OBJECT_ID( 'tempdb..#test') IS NOT NULL DROP TABLE #testCREATE TABLE #test (httpfield VARCHAR(500))INSERT INTO #testSELECT 'acbdsafsdfasd <a href="/blahblah"> blahblah </a> happy days are here again!' UNION ALL SELECT 'a12312340934241239837458923041029341092 <a href="/yummynummy"> yummynummy </a> xyzalkdfjsa'SELECT PATINDEX( '%<a href=%', httpfield ) AS StartingChar, CHARINDEX( '>', httpfield, PATINDEX( '%<a href=%', httpfield ) +1) AS EndingBracket, STUFF( httpfield, PATINDEX( '%<a href=%', httpfield ), CHARINDEX( '>', httpfield, PATINDEX( '%<a href=%', httpfield ) +1) - PATINDEX( '%<a href=%', httpfield ) + 1, '' ) AS RemovedFirstTag, CHARINDEX( '</a>', httpfield, PATINDEX( '%<a href=%', httpfield )) AS AnchorTagStart, STUFF( httpfield, CHARINDEX( '</a>', httpfield, PATINDEX( '%<a href=%', httpfield )) , 4, '') AS RemovedCorrectAnchor, STUFF( STUFF( httpfield, CHARINDEX( '</a>', httpfield, PATINDEX( '%<a href=%', httpfield )) , 4, ''), PATINDEX( '%<a href=%', httpfield ), CHARINDEX( '>', httpfield, PATINDEX( '%<a href=%', httpfield ) +1) - PATINDEX( '%<a href=%', httpfield ) + 1, '' ) FinalRemovalFROM #test[/code]Also, note how I created consumable test data at the beginning. This will help us help you in the future, if you do that.Thu, 03 Feb 2011 14:52:53 GMTEvil Kraig Fhttp://www.sqlservercentral.com/Forums/Topic1058310-392-1.aspxBut... <a href="/back_to_school"> this string keep changing for 1 column it is 'back_to_School' and for another it is 'doctos_report' etcOnly constant that chage is <a href="/xxxxxxxxxxxx">xxxxxxxxxxxx</a>where xxxxxxxxxxxx keeps changing from column to columnThu, 03 Feb 2011 14:24:40 GMTNarendra-274001http://www.sqlservercentral.com/Forums/Topic1058310-392-1.aspxDon't have enough to really go on, but this will get ou started. You can pick off the remaining end tagdeclare @xml varchar(100)set @xml = 'Featured in <a href="/back_to_school">Back to School</a>' select @xml, charindex('>',@xml),stuff(@xml,12,charindex('>',@xml)-11 ,' ')JimThu, 03 Feb 2011 13:48:20 GMTskt5000http://www.sqlservercentral.com/Forums/Topic1058310-392-1.aspxSELECT *,REPLACE(REPLACE(data,'<a href="/back_to_school">',''),'</a>','')FROM tempWHERE data != ''AND data like '%<a href=%'Thu, 03 Feb 2011 13:35:20 GMTLutzMhttp://www.sqlservercentral.com/Forums/Topic1058310-392-1.aspxHello All...Can anyone help me with implementing a script that does the followingsearch for html tag in one of the columns and empty them with blankFor example :If the value in a column is == Featured in <a href="/back_to_school">Back to School</a>I have to update this as == Featured in Back to SchoolMeans, I have to remove ' <a href="/back_to_school"> </a> ' tag from columnI have to do this for all the rows of this column in the table.I just tried this SELECT * FROM tempWHERE data != ''AND data like '%<a href=%'Not sure how to proceed from here Can some one help me with this Thu, 03 Feb 2011 12:34:00 GMTNarendra-274001