Hello MySQL Users
Is there a way to change the separator in the following example,
e.g. from "," to "'"?
SELECT FORMAT(12332.123456, 4);
-> '12,332.1235'
is this the easiest way?
SELECT REPLACE(FORMAT(12332.123456, 4), ",", "'");
-> '12'332.1235'
or can this be set somewhere?
Thank you!
Jay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw
