title: Msg 8114, Level 16, State 5, Line 3 Error converting data type varchar to float
body: <p>I am trying to apply a where clause my script is like</p>
  
  <pre><code>set ansi_nulls off
  
  select
      Name, Count(Distinct [Document Name])
  from 
      dbo.timeless
  where 
      origin in ('2', 'I', 'E')
      and [svs check] IN ('0', '.', 'NO', 'OK', '#N/A')
  </code></pre>
  
  <p>Then I get the error </p>
  
  <blockquote>
    <p>Msg 8114, Level 16, State 5, Line 3<br>
    Error converting data type varchar to float</p>
  </blockquote>
  
  <p>When I comment out <code>[svs check]</code>, everything goes fine. So the problem is in <code>[svs check]</code>. Kindly help. </p>