Re: formatting currency in mysql

2002-05-06 Thread Issvar
SELECT FORMAT(yourvalue,2) - Original Message - From: "Graeme B. Davis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 06, 2002 10:16 PM Subject: formatting currency in mysql > Does anyone have a quick tip on how to format a float/numeric in

formatting currency in mysql

2002-05-06 Thread Graeme B. Davis
Does anyone have a quick tip on how to format a float/numeric in the following currency format with a query? $xx,xxx.xx Thanks! Graeme - Before posting, please check: http://www.mysql.com/manual.php (the manual) http