rupees format

lily611 · October 25th, 2004, 04:47 AM

Hi
I am working in .Net on which i have to retrieve the rupees from database with comma eg. 215000 will be displayed in the report as 2,15,000. I dont know how to write the sql statement to get the rupees format with comma.
Can anyone help me as soon as possible.

Regards
Lily

happygv · October 25th, 2004, 06:34 AM

Hi Lily,

Not sure if you could easily do that using SQL. But that is easlily done in .Net using C#.

Code:

String.Format("{0:#,###}", VariableName);

You can play around with that.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

lily611 · October 25th, 2004, 08:02 AM

How to display in datagrid?

happygv · October 25th, 2004, 08:07 AM

That gets off topic, you should post that on .net forum here, where you would get better assistance on that. This is an SQL server forum.

Cheers!

_________________________
- Vijay G
Strive for Perfection