title: Insert Select will not convert or cast NVARCHAR to Float
body: <p>I'm am trying to do an insert select statement to move all data from one table to another..  Two of the columns in the source table have a datatype of <code>NVARCHAR</code> and the destination tables have a datatype of <code>Float</code>. </p>
  
  <p>I have attempted to use <code>cast</code> and <code>convert</code> but I keep getting the following message:        </p>
  
  <blockquote>
    <p>Error converting data type nvarchar to float.</p>
  </blockquote>
  
  <p>Code:</p>
  
  <pre><code>INSERT INTO Destination_Table
        ([SCAC]
        ,[Date]
        ,[Orgin]
        ,[Destination Low Zip]
        ,[Destination High Zip]
        ,[Class]
        ,[Minimum Charge]
        )
  
  SELECT [SCAC]
        ,[Date]
        ,[Origin]
        ,cast([Destination Low Zip]   as float)
        ,cast([Destination High Zip]  as float)
        ,[Class]
        ,[Minimum Charge]
  
    FROM source_table
  </code></pre>