How to convert varchar to float in SQL Server?
<p>I'm trying to convert a <code>varchar</code> to a <code>float</code> and getting the following message.</p>

<blockquote>
  <p>Msg 8114, Level 16, State 5, Line 41<br>
  Error converting data type varchar to float. The statement has been terminated.</p>
</blockquote>

<p>This is what I tried.</p>

<pre><code>ALTER TABLE All_Active
ALTER COLUMN [BE #] float
</code></pre>

<p>Please tell me there is an easy solution for this.  This should be <code>float</code>.  It imported into SQL Server incorrectly.</p>