title: How do I convert a number to a numeric, comma-separated formatted string?
body: <p>Is there an easy way to convert a number (in my case an integer) to a comma separated <code>nvarchar</code> string?</p>
  
  <p>For instance, if I had an <code>int</code> value of <code>1000000</code> stored in a field, how can I convert it to an <code>nvarchar</code> string with the outputted result of "1,000,000"?</p>
  
  <p>I could easily write a function to do this but I wanted to be sure there wasn't an easier way involving a call to either <code>CAST</code> or <code>CONVERT</code>.</p>