title: Use the stuff replace function in SQL Server 2008 to replace <div> tags and strings inside the div tags as well
body: <p>I am having a hard time using stuff / replace function to remove the existing div tags in the records and the string inside the divs as well.</p>
  
  <p>Here is a sample record.</p>
  
  <pre><code>&lt;p&gt;  &lt;span style="font: 16px/15.18px 돋움; color: rgb(51, 51, 51); text-transform: none; text-indent: 0px; letter-spacing: normal; word-spacing: 0px; float: none; display: inline !important; white-space: normal; font-size-adjust: none; font-stretch: normal; background-color: rgb(255, 255, 255); -webkit-text-stroke-width: 0px;"&gt;サンルイズ大広場は昔、&lt;/span&gt;&lt;wbr style="font: 16px/15.18px 돋움; color: rgb(51, 51, 51); text-transform: none; text-indent: 0px; letter-spacing: normal; word-spacing: 0px; white-space: normal; font-size-adjust: none; font-stretch: normal; background-color: rgb(255, 255, 255); -webkit-text-stroke-width: 0px;" /&gt;&lt;span style="font: 16px/15.18px 돋움; color: rgb(51, 51, 51); text-transform: none; text-indent: 0px; letter-spacing: normal; word-spacing: 0px; float: none; display: inline !important; white-space: normal; font-size-adjust: none; font-stretch: normal; background-color: rgb(255, 255, 255); -webkit-text-stroke-width: 0px;"&gt;イントラムロス地域の名前の中で一つを選んで作られたもので、&lt;/span&gt;&lt;wbr style="font: 16px/15.18px 돋움; color: rgb(51, 51, 51); text-transform: none; text-indent: 0px; letter-spacing: normal; word-spacing: 0px; white-space: normal; font-size-adjust: none; font-stretch: normal; background-color: rgb(255, 255, 255); -webkit-text-stroke-width: 0px;" /&gt;&lt;span style="font: 16px/15.18px 돋움; color: rgb(51, 51, 51); text-transform: none; text-indent: 0px; letter-spacing: normal; word-spacing: 0px; float: none; display: inline !important; white-space: normal; font-size-adjust: none; font-stretch: normal; background-color: rgb(255, 255, 255); -webkit-text-stroke-width: 0px;"&gt;カサマニラ、カサブランカ、カスウルタネタ、ロスヒタルコウス、&lt;/span&gt;&lt;wbr style="font: 16px/15.18px 돋움; color: rgb(51, 51, 51); text-transform: none; text-indent: 0px; letter-spacing: normal; word-spacing: 0px; white-space: normal; font-size-adjust: none; font-stretch: normal; background-color: rgb(255, 255, 255); -webkit-text-stroke-width: 0px;" /&gt;&lt;span style="font: 16px/15.18px 돋움; color: rgb(51, 51, 51); text-transform: none; text-indent: 0px; letter-spacing: normal; word-spacing: 0px; float: none; display: inline !important; white-space: normal; font-size-adjust: none; font-stretch: normal; background-color: rgb(255, 255, 255); -webkit-text-stroke-width: 0px;"&gt;エルヨーガ、フィリピノで作られた商業複合団地。&lt;/span&gt;&lt;/p&gt;
  </code></pre>
  
  <p>(After this, someone injected the table records containing the following below.)</p>
  
  <pre><code>&lt;div style="display:none"&gt;&lt;h3&gt;suprax 100mg 5ml suspension dosage&lt;/h3&gt;suprax for gonorrhea &lt;a href="http://www.dunshaughlinac.com/news-details.asp?id=112"&gt;suprax&lt;/a&gt; buying suprax without a script&lt;/div&gt;&lt;div style="display:none"&gt;&lt;h3&gt;suprax 400mg&lt;/h3&gt;buy suprax online uk &lt;a href="http://www.dunshaughlinac.com/news-details.asp?id=112"&gt;suprax&lt;/a&gt; overnight suprax canada&lt;/div&gt;&lt;div style="display:none"&gt;&lt;h3&gt;1-800-gambler.org&lt;/h3&gt;call 1-800-gambler &lt;a href="http://www.800gambler.org/"&gt;http://www.800gambler.org/&lt;/a&gt; teen gambling&lt;/div&gt;&lt;div class="inpspjdeq"&gt;&lt;div style="display:none"&gt;&lt;h3&gt;buy clarithromycin no prescription&lt;/h3&gt;buying biaxin &lt;a href="http://www.geospatialworld.net/Event/View.aspx?EID=63#buyclarithromycin"&gt;order biaxin&lt;/a&gt; buy discount clarithromycin&lt;/div&gt;&lt;/div&gt;&lt;script type="text/javascript"&gt;xjswyvnyg=document.getElementsByClassName("inpspjdeq");for(stqxrhhl=0;stqxrhhl!=xjswyvnyg.length;++stqxrhhl){xjswyvnyg[stqxrhhl].style.visibility="hidden";}&lt;/script&gt;&lt;div style="display:none"&gt;&lt;h3&gt;buy clarithromycin without prescription&lt;/h3&gt;cheapest clarithromycin &lt;a href="http://www.geospatialworld.net/Event/View.aspx?EID=63#buyclarithromycin"&gt;order biaxin 500mg&lt;/a&gt; generic clarithromycin&lt;/div&gt;&lt;div style="display:none"&gt;&lt;h3&gt;order biaxin tablets&lt;/h3&gt;cheapest biaxin &lt;a href="http://www.geospatialworld.net/Event/View.aspx?EID=63#buyclarithromycin"&gt;buy clarithromycin&lt;/a&gt; cheapest clarithromycin&lt;/div&gt;&lt;div style="display:none"&gt;&lt;h3&gt;buy clarithromycin australia&lt;/h3&gt;order clarithromycin 500mg &lt;a href="http://www.geospatialworld.net/Event/View.aspx?EID=63#buyclarithromycin"&gt;buy clarithromycin&lt;/a&gt; buy discount biaxin&lt;/div&gt;&lt;div style="display:none"&gt;&lt;h3&gt;order clarithromycin 500mg&lt;/h3&gt;clarithromycin online &lt;a href="http://www.geospatialworld.net/Event/View.aspx?EID=63#buyclarithromycin"&gt;buy biaxin 250mg&lt;/a&gt; purchasing clarithromycin&lt;/div&gt;&lt;div style="display:none"&gt;&lt;h3&gt;buy clarithromycin 500mg&lt;/h3&gt;order clarithromycin 250mg &lt;a href="http://www.geospatialworld.net/Event/View.aspx?EID=53"&gt;buy clarithromycin&lt;/a&gt; buy biaxin usa&lt;/div&gt;&lt;div style="display:none"&gt;&lt;h3&gt;buy biaxin pills&lt;/h3&gt;buy clarithromycin usa &lt;a href="http://www.geospatialworld.net/Event/View.aspx?EID=43"&gt;buy clarithromycin&lt;/a&gt; buy clarithromycin without prescription&lt;/div&gt;
  </code></pre>
  
  <p>As you can see there are numerous nested divs as well, and I am trying to use the stuff method to replace the following with an empty string ''.</p>
  
  <p>Thanks in advance!</p>