title: Cannot cast nvarchar to float
body: <p>I have a weird problem.</p>
  
  <p>In my query I select 5 columns which two of them are <code>nvarchar</code> in the form of numeric (only contains number and precision point), and other three are <code>uniqueIdentifier</code> and <code>nvarchar</code>. </p>
  
  <p>I want to cast these two columns to <code>Float</code> in my select statement but I'm getting an error </p>
  
  <blockquote>
    <p>Cannot cast nvarchar to float.</p>
  </blockquote>
  
  <p>I checked the format of all these values many many times. Trust me, they are fine.</p>
  
  <p>But when I just select these two columns and cast them to float the query runs successfully.</p>
  
  <p>I appreciate any help on this subject.</p>
  
  <p>I can paste the query here too. but the whole query is more then 100 lines and this will be frustrating to write and read!</p>