Formatting db output in math standrad format

[yasirkhan768]

Hi every 1.
can any told me how to format a db out put i.e 250000 in this format 2,50,000.00
db value can be of any size.
thanks in advance

[pbmods]

Heya, yasirkhan. Welcome to TSDN!

What database server software are you using?

In MySQL, you can use the FORMAT() function.

[yasirkhan768]

Heya, yasirkhan. Welcome to TSDN!

What database server software are you using?

In MySQL, you can use the FORMAT() function.

Thanks .im using MYSQL.and my problem has been solved.thanks again.

[pbmods]

Heya, yasirkhan768.

Glad to hear you got it working.

Good luck with your project, and if you ever need anything, post back anytime!