AnsweredAssumed Answered

How to format a number on a SQL Query

Question asked by Fred(CH) on Mar 14, 2014


How to format a number on a SQL Query


     Hello there,

     I am a beginner regarding the use of ExecuteSQL function. After numerous searches on the documentation and the web, i am unable to find the way to format a number within the SELECT clause.

     For instance :

ExecuteSQL ("SELECT Id_employee, SUM (Amount) FROM Salary GROUP BY Id_employee"

     ; " " ; ¶ )


is getting theses :


     10 5000

     11 2500

     12 3000


how to modify the query to get theses :


     10 5'000.00

     11 2'500.00

     12 3'000.00



     Thank you so much for your help !


     Bye, Fred


PS: I think it is also related to ExecuteSQL returns wrong format for decimal numbers with international system settings.