<p>I'm looking to use SQL to format a number with commas in the thousands, but no decimal (so can't use Money) - any suggestions?</p>

<p>I'm using SQL Server 2005, but feel free to answer for others as well (like MySQL)</p>

In MySQL, the
```
FORMAT()
```
function will do the trick.