title: Cast into a decimal with a specified amount of decimal places
body: <p>Is there any way to cast a number into a decimal with a specified number of decimal places? I tried:</p>
  
  <pre><code>SELECT ...
         CAST(NumericField AS NUMERIC(15, @DecimalPlaces) AS NumericField,
         ...
  </code></pre>
  
  <p>But it didn't work.</p>
  
  <hr>
  
  <p><strong>EDIT</strong>: I made a mistake and wrote <code>NUMBER</code> instead of <code>NUMERIC</code>. But the question stands still: How do I cast to a <code>NUMERIC</code> with a specified number of decimal places?</p>