Convert full column from nvarchar to float
<p>I have a question how can I convert a SQL Server column with data of type <code>nvarchar</code> to float?</p>

<p>Classic query:</p>

<pre><code>ALTER TABLE &lt;column&gt;
ALTER COLUMN &lt;column&gt; FLOAT;
</code></pre>

<p>works only with an empty column.</p>

<p>Is there any way to do this?</p>

<p>Thanks!</p>