title: How to eliminate decimal places from a built-in sql function?
body: <p>I have the following SQL Server query:</p>
  <pre><code>select max(AveragePrice) as [LARGEST AVERAGE]
  from
      (select b.brand_id, round(avg(prod_price),2) as AveragePrice
      from lgbrand b, lgproduct p
      where b.brand_id = p.brand_id
      group by b.brand_id) x
  </code></pre>
  <p>Output</p>
  <pre><code>LARGEST AVERAGE
  22.590000
  </code></pre>
  <p>How do I trim the decimals to only show &quot;22.59&quot;?</p>