title: Updating the NaN value in a DataBase
body: <p>I have a Old database in which there is a table containing columns(<strong>dataType REAL</strong>) with <strong>NaN( Not a Number)</strong> values. Now if I query on these tables then I am getting errors. So to update these I tried the following query: </p>
  
  <pre><code>UPDATE Table SET column = 0 WHERE IsNumeric(column)=0
  </code></pre>
  
  <p>But even this query failed throwing error </p>
  
  <blockquote>
    <p>"returned invalid data for column ".</p>
  </blockquote>
  
  <p>If the <strong>datatype of the column is varchar then I could have easily updated.</strong> But the Column is <strong>REAL</strong> so I am not able to update the table. Help me I am really stuck with this issue for two days.</p>