Not really a MySQL problem, this is a presentation problem. MySQL will store the number as digits only (unless you are storing in a character field - but why would you?). If using PHP, for instance, the output of the field would be
number_format($fieldvalue) or if you want the answer to two decimal places number_format($fieldvalue, 2) Regards Terry http://booksihaveread.awardspace.co.uk ----- Original Message ----- > *From:* coolcoder <[EMAIL PROTECTED]> > *To:* mysql@lists.mysql.com > *Date:* Thu, 23 Aug 2007 03:55:27 -0700 (PDT) > > 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? > > > > > > > www.coderewind.com > Best Place to hunt for Code > -- > View this message in context: > http://www.nabble.com/seoparator-help-tf4316769.html#a12291343 > Sent from the MySQL - General mailing list archive at Nabble.com. > -- No virus found in this outgoing message. Checked by AVG. Version: 7.5.484 / Virus Database: 269.12.2/967 - Release Date: 22/08/2007 18:51 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]