Thank you Simon exactly what I was looking for. Appreciate the assistance.
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Custom Programming & Web Hosting Services
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
----- Original Message -----
From: Simon Griffiths
To: 'Mike Blezien' ; 'MySQL List'
Sent: Sunday, February 12, 2012 10:26 AM
Subject: RE: Formatting Numbers with commas
Please see
http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_format
Regards,
Simon Griffiths
-----Original Message-----
From: Mike Blezien [mailto:mickalo@stripped]
Sent: 12 February 2012 16:00
To: MySQL List
Subject: Formatting Numbers with commas
Hello,
Is there a function to automatically format long numercial values before
it's entered into the table, i.e I have a value like 159600 and would be
entered as
159,600 or 78450 would be entered 78,450 etc., ?
Thank you,
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Custom Programming & Web Hosting Services
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
