title: Make a select statement output a number with commas
body: <p>I am using SQL Server and am trying to figure out how to make a select statement output a number separated by commas. I am only able to find how to transform a number into a number with commas, which isn't what I want. The following code is the code I am trying to get to output as a number with commas. Right now when you execute the statement it returns a value of 750000.00 and I want it to return 750,000.00.</p>
  
  <p>Code:</p>
  
  <pre><code>select max(c.salary) as MaxSalary
  from #Career c inner join
       #Member m
      on c.Member_ID = m.Member_ID
  where m.age &lt; 35
  </code></pre>