How to display number separated by commas

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

How to display number separated by commas

Author

Topic

MDiwakar
Starting Member

6 Posts

Posted - 2008-01-22 : 07:23:05

Is there anyway to display a number separated by commas.
Say for example :

a=500000

This should be displayed as 5,00,000

Thanks in advance.

sunil
Constraint Violating Yak Guru

282 Posts

Posted - 2008-01-22 : 07:25:20

Where do you want to display result of it i.e. what application (platform) you are working on?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-01-22 : 07:25:55

guess this is a front end issue. Better to do it at ur front end.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-01-22 : 07:26:01

do this in your front end application

use money data type


declare @a money

select	@a = 50000

select	convert(varchar(10), @a, 1)

KH
[spoiler]Time is always against us[/spoiler]

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-01-22 : 07:26:54

DAMN ! double

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources