title: How can I remove every occurence of "<p>&nbsp;</p>" from the data in a column in SQL Server?
body: <p>I am using SQL Server 2012 and I have this table with data that I need to clean up. </p>
  
  <p>I am trying to convert this to XML but first I need to remove every occurence of <code>&lt;p&gt;&amp;nbsp;&lt;/p&gt;</code> <strong>that appears inside text</strong> inside the <code>Text</code> column:</p>
  
  <pre><code>CREATE TABLE [dbo].[Detail] (
      [DetailId]       INT             IDENTITY (1, 1) NOT NULL,
      [Text]            NVARCHAR (4000) NULL,
      [Detail]          NVARCHAR (4000) NULL,
      CONSTRAINT [PK_Detail] PRIMARY KEY CLUSTERED ([DetailId] ASC)
  );
  </code></pre>
  
  <p>Can anyone suggest how I could do this? Please note that I am not at this time wanting to convert anything to XML. I would just like to remove this text string or would it be more appropriate to say replace it with "". </p>
  
  <p>Thanks</p>