title: SQL Data conversion & division
body: <p>I'm trying to write an SQL statement that would indicate what kind of commission is being given. I'm stuck on the last part that shows what percentage is given because SQL won't convert a char value to money. 
  I'm new to this so my conversion attempt may be entirely bogus.</p>
  
  <pre><code>CASE 
     WHEN VehicleSales.CommissionSP1 ='500' then 'Flat'
     WHEN VehicleSales.CommissionSP1 = '0' then 'Not Applicable'
        else Convert(int, VehicleSales.CommissionSP1) / Convert (int, VehicleSales.GrossProfit)
  END AS Commission_Type
  </code></pre>