title: Replace ; with blank in SQL
body: <p>I have a table like this:</p>
  
  <pre><code>DECLARE @T TABLE
  (note VARCHAR (50))
  
  INSERT @T
  SELECT 'Amplifier'
  UNION ALL SELECT ';'
  UNION ALL SELECT 'Regulator'
  </code></pre>
  
  <p>How can I replace the semicolon (<code>';'</code>) with blank (<code>''</code>).</p>
  
  <p>Expected Output:</p>
  
  <pre><code>Amplifier
  ''         --  here semicolon replace with blank
  Regulator
  </code></pre>