Learn something every day..... TFT
----- Original Message ----- > *From:* "Andrew Braithwaite" <[EMAIL PROTECTED]> > *To:* "coolcoder" <[EMAIL PROTECTED]>, <mysql@lists.mysql.com> > *Date:* Thu, 23 Aug 2007 14:19:25 +0100 > > mysql> select format(3000000,0); > +-------------------+ > | format(3000000,0) | > +-------------------+ > | 3,000,000 | > +-------------------+ > 1 row in set (0.00 sec) > > mysql> select format(3000000,2); > +-------------------+ > | format(3000000,2) | > +-------------------+ > | 3,000,000.00 | > +-------------------+ > 1 row in set (0.00 sec) > > Cheers, > > Andrew > > -----Original Message----- > From: coolcoder [mailto:[EMAIL PROTECTED] > Sent: Thu, 23 August 2007 11:55 > To: mysql@lists.mysql.com > Subject: seoparator help > > > Was wondering if anyone could help me with this little problem I'm > having. > I'd like to have a comma separator after every 3 digits. E.g > "3,000,000". > How would i go about this? > > > > > > > This message has been scanned for viruses by BlackSpider MailControl > - www.blackspider.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- > No virus found in this incoming message. > Checked by AVG. > Version: 7.5.484 / Virus Database: 269.12.2/967 - Release Date: > 22/08/2007 18:51 > > Terry http://booksihaveread.awardspace.co.uk -- No virus found in this outgoing message. Checked by AVG. Version: 7.5.484 / Virus Database: 269.12.4/969 - Release Date: 23/08/2007 16:04 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]