adding commas into integer

while selecting the field, I want it to be display with commas.
for example,
10000 become 10,000
without decimal placed at the end.
I have tried using smallmoney format but there is decimal places.Take a look at DECIMAL datatype
"dapdap" <dapdap@.discussions.microsoft.com> wrote in message
news:22FBBC46-4B9D-4377-A806-D4D79EE81013@.microsoft.com...
> while selecting the field, I want it to be display with commas.
> for example,
> 10000 become 10,000
> without decimal placed at the end.
> I have tried using smallmoney format but there is decimal places.|||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 divantages for performance,
complexity and special handling at the client?
David Portas
SQL Server MVP
--
"dapdap" wrote:

> while selecting the field, I want it to be display with commas.
> for example,
> 10000 become 10,000
> without decimal placed at the end.
> I have tried using smallmoney format but there is decimal places.|||>> selecting the field, I want it to be display with commas. <<
Let's get back to the basics of an RDBMS. Rows are not records; fields
are not columns; tables are not files. In a tiered architecture, the
display formatting is done in the front end and never in the database.
A good SQL programmer avoids proprietary datatypes.

Adding a value to a URL

i have been told that

="http://www.somewhere.com/" + CStr(Fields!CUNAME.Value)

placed in a textboxes expression field (in the jumptoURL box ) will allow for the URL to be generated, however when i type this in, the report doesnt recognizes it as a hyperlink

any ideas to whet im doing wrong!

Possibly this will help you:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=858533&SiteID=1

Edit: As you can see, the only results that spam will get you is a locked thread.

|||

Jnasch, you post is locked.

Anyhow, the answer is

="javascript:void window.open('http://www.onsemi.com/PowerSolutions/product.do?id=" & CStr(Fields!WEB_PART_NAME.Value) & "','_blank')"

Philippe

|||

Thank you Phillippe. I proposed a similar solution.

|||Thank you very much, this has helped me greatly|||

You're welcome. I know technology can be extremely frustrating at times. Let us know if we can help with anything else.