p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Language (http://p2p.wrox.com/forumdisplay.php?f=100)
-   -   Inserting comma in the field (http://p2p.wrox.com/showthread.php?t=66043)

issaq February 20th, 2008 08:41 AM

Inserting comma in the field
 
I had an column called "amount". I have to append "," from the last 3 characters.
E.g:
    amount output
     10000 10,000
      100 100
        0 0
     10000000 10,000,000


Pls help me out.



All times are GMT -4. The time now is 08:02 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.