title: SQL Server select where sql_variant equal doesn't work?
body: <p>I'm using SQL Server 2008 </p>
  
  <p>I have a column called <code>varEnteredValue</code> of datatype <code>sql_Variant</code>. </p>
  
  <p>When I execute the following select statement I don't get anything </p>
  
  <pre><code>SELECT * FROM tblname WHERE varEnteredValue = 1 
  </code></pre>
  
  <p><em>Notice</em> I have many values with value 1 in this column </p>
  
  <p><strong>Question</strong> </p>
  
  <p>How can I fix this issue? Do I need to convert data type ? </p>