title: cast or convert a float to nvarchar?
body: <p>I need to select from one column of datatype float and insert it in another column as nvarchar.</p>
  
  <p>I tried to cast it: <code>cast([Column_Name] as nvarchar(50))</code></p>
  
  <p>The result was <code>9.07235e+009</code> instead of a 10 digit number (phone number). </p>
  
  <p>Does any one know how to cast or convert this data properly?</p>