title: Format a number with commas but without decimals in SQL Server 2008 R2?
body: <p>I am using the following to create a comma formatted number in T-SQL. How can I get rid of the decimal point and the digits after decimal. So if I get 1,112.00 after formatting, how would I get only 1,112?</p>
  
  <pre><code>SELECT CONVERT(varchar, CAST(1112 AS money), 1)
  </code></pre>