title: How to separate positive and negative numbers into their own columns?
body: <p>I have a table with the following columns and data:</p>
  
  <pre><code>activity_dt | activity_amt
   2009-01-01 |   -500
   2009-01-01 |    750
  </code></pre>
  
  <p>Can I write a query that looks at the sign of <code>activity_amt</code> and puts it in the credits column if it's positive, and the debits column if it's negative? (I'm using Sybase)</p>
  
  <pre><code>activity_dt | debits | credits
   2009-01-01 |  -500  |   750
  </code></pre>