title: Convert Numeric value like 177200 to 1772.00 in T-SQL statement
body: <p>In SQL Server, I have a query that returns a value of 177200. I need this value represented as 1772.00 as the last 2 digits are past the decimal. The query below is adding .00 to the end of the full value. I have no experience in this type of SQL statement. Any help would be appreciated. </p>
  
  <pre><code>SELECT 
      STR(SUM(ActualPrice), 10, 2) AS Total, Department 
  FROM  
      #DepartmentSalesData
  GROUP BY 
      Department
  </code></pre>