title: SQL Query to truncate to two decimal points?
body: <p>I have a pretty big query at the moment and I am missing one element... I need to cut the data to two decimal points (no rounding needed). I Googled but have had trouble adapting it to the current query. </p>
  
  <pre><code>SELECT 
      FechaDeSistema, Code, 
      CASE 
          WHEN DR_Socio = @SocioNum THEN Cantidad 
      END as Debit, 
      CASE 
          WHEN CR_Socio = @SocioNum THEN Cantidad 
      END AS Credit, 
      CASE 
          WHEN DR_Socio = @SocioNum THEN BalanceDebito 
          WHEN CR_Socio = @SocioNum THEN BalanceCredito 
      END AS Balance 
  FROM 
      Ledger 
  WHERE 
      (Debito_Cuenta = @Acct) OR 
      (Credito_Cuenta = @Ncct) 
  ORDER BY 
      FechaDeSistema DESC
  </code></pre>
  
  <p>I basically need to truncate the Credit and Debit "cases" (is that how you say that?) to two decimal points. How can I pull it off? Thanks in advance!</p>