title: SQL Conversion failed when converting the varchar value 'AJH 123' to data type int
body: <p>I have a select statement what i need to run a case statement on it to check for a value first and then enter decide which column to get. </p>
  
  <p>the start of the call is this </p>
  
  <pre><code>select 
  case when req.ReportStatusCode in ('draft','submitted') then 
  req.ID else 
  req.reportNumber
  end as [Request Id \ Report Number],
  </code></pre>
  
  <p>however when I call this i get an error </p>
  
  <blockquote>
    <p>Conversion failed when converting the varchar value 'AJH 123' to data type int.</p>
  </blockquote>
  
  <p>this is the report number field and ive no idea how i could stop this. </p>
  
  <p>any and all help much appreciated </p>