I want to output my numeric data in comma format. For example, 1000 would be 1,000.

Is there a native function in TSQL, or do I need to format in my programming code?

Thanks in advance.

- - - - - - - - - - - - - - - - - - - - - - -
In God we trust, everything else we test.

Presentation issues should really be addressed at the front-end. SQLServer is a database engine, not a printing/formatting system and as such has very limited formatting capabilities. Also, from a deployment aspect, it's much simpler to have the front-end deal with any localisation issues e.g date styles than attempt to build the logic for it in SQL.

Chris


There are two secrets to success in this world:
1. Never tell everything you know

I normally do this sort of thing on the front end as well, but I was hoping to to have the data returned "ready to go". No worries.

Thank you.

- - - - - - - - - - - - - - - - - - - - - - -
In God we trust, everything else we test.

P.S. - As for localization issues, the system involved is geographically intended for a single US state. In that regard, I have fewer issues to work out.

- - - - - - - - - - - - - - - - - - - - - - -
In God we trust, everything else we test.