title: Sql Server select money with comma
body: <p>I have <strong>Payment</strong> table in ms sql server.</p>
  
  <p>Payment table has below column type of <strong>money</strong></p>
  
  <pre><code>Salary 
  </code></pre>
  
  <p><strong>Salary</strong> column has below values </p>
  
  <pre><code>1495.88
  
  2235.08
  
  719.59
  
  15.75
  
  9.59
  
  0.00
  
  NULL
  
  97.77
  </code></pre>
  
  <p>When i select query as below,</p>
  
  <pre><code>select Salary from Payment where 
  </code></pre>
  
  <p><strong>Result</strong> must be below</p>
  
  <pre><code>1,495,88
  
  2,235,08
  
  719,59
  
  15,75
  
  9,59
  
  0,00
  
  NULL
  
  97,77
  </code></pre>
  
  <p>I tried below </p>
  
  <pre><code>SELECT CONVERT(varchar, CAST(Salary AS money), 1) from  Payment 
  </code></pre>
  
  <p>this did not work for me.</p>
  
  <p>How can i get money as comma format </p>
  
  <p>thanks</p>