title: Conversion failed when converting the varchar value to data type smallint
body: <p>Running a select statement against a table with a column of smallint and receiving above error:</p>
  
  <pre><code>SELECT * FROM [Database].[dbo].[TableName]
  where ColumnName = 'ABC123'
  </code></pre>
  
  <p>I know smallint needs to be an integer but in the table, the data contains mixed data (i.e. ABC123); how can I run the select statement without modifying the datatype? When I try to modify the datatype, SQL tells me I need to drop and recreate the table which I cannot do... </p>
  
  <p>Thanks! </p>