while selecting the field, I want it to be display with commas.
for example,
10000 become 10,000
without decimal placed at the end.

Formatting is controlled by your client application, not by SQL Server. Ask
this question in a forum for the app or programming language you are using.

Certainly you could get SQL to return a string instead of a number but why
would you want to do that with the obvious disadvantages for performance,
complexity and special handling at the client?

--
David Portas
SQL Server MVP
--



[quoted text, click to view]