title: Inserting NaN value into a float column
body: <p>I need help inserting a NaN value in a float column as 0 in SQL Server 2012.</p>
  
  <p>The data I have inserted into a database is coming from an active directory and sometimes it's generated NaN values, but my database column is defined as a float because I want to get those values from database and do some calculations.</p>
  
  <pre><code>Dim value1 As Double 
  
  sql = "INSERT INTO usb_compliance (Date,atc,value1,) VALUES ('" &amp; Now.Date &amp; "','CMB','" &amp; value1 &amp;"' )" 
  </code></pre>