Conversion failed when converting the varchar value to data type smallint
<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>