title: How to properly use SQL CASE statement
body: <p>How do I use a CASE statement to apply to all values corresponding to a specific field in a column?  </p>
  
  <p>For example, I want all payments in every column to appear as negatives but this only applies to the first column.  Also, I want it to apply to all payments in every column.</p>
  
  <pre><code> CASE WHEN ardoc.DocType = 'PA' 
        THEN arDoc.DocBal*(-1) ELSE ardoc.DocBal 
   END AS [Document Balance]
  </code></pre>
  
  <p>Note:  'PA' stands for payments</p>