List:General Discussion« Previous MessageNext Message »
From:Jay Date:May 23 2006 7:48am
Subject: String functions FORMAT(X,D)
View as plain text  
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
Thread
• String functions FORMAT(X,D)Jay23 May