title: Doing Arithmetic on VARCHAR columns
body: <p>The 3 fields below 'Winning', 'BuyIn', 'ChampFund' are VARCHAR datatype with values that include a $ character like $250.00</p>
  
  <p>Example of the result I'm looking for:</p>
  
  <p>'Winnings' - 'BuyIn' - 'ChampFund' As 'Net'<br/>
     $250    -   $45   -     $5      =  $200 </p>
  
  <p>If they were  INT datatype I would </p>
  
  <pre><code>Select *, Winnings - BuyIn - ChampFund As Net From gamedetail
  </code></pre>
  
  <p>Any suggestion as to how to accomplish this would be appreciated. </p>