Replace ; with blank in SQL
<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>