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/[EMAIL PROTECTED]

Reply via email to