title: Conversion failed when converting the varchar value 'C000000055' to data type int
body: <p>I have this query: </p>
  
  <pre><code>SELECT
  cast(co_num as varchar),
  activity_date, 
  due_date 
  FROM coitem_log_mst
  WHERE cast(co_num as varchar) = 3199 and co_line = 10 and co_release = 0
  ORDER BY activity_date
  </code></pre>
  
  <p>and I am getting this error:</p>
  
  <pre><code>Conversion failed when converting the varchar value 'C000000055' to data type int.
  </code></pre>
  
  <p>I have tried various conversions and putting the co_num value in ' '. But still get the error. Please advise...</p>