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]

Reply via email to