[dba-SQLServer] Formatting Numbers IN SQL

Since I didn't get a reply I will try another tact.

There doesn't seem to be an SQL equivalent to the Access 
Format(12345,"#,##0").  What is the simplest way of taking a number 
like 12345.00 and converting it to a varchar "12,345"?


Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand