title: Conversion failed when converting the varchar value '300.00' to data type int
body: <p>Is there a way to get rid of this error when using the following sql case when query?As some of the fields are varchar due to they way they were imported?</p>
  
  <pre><code>select * ,
  case when [Month] = '200911' then netpay_nov09
   when [Month] = '200912' then netpay_dec09
   when [Month] = '201001' then netpay_jan10
  end as m1
  </code></pre>