0 Replies Latest reply on Mar 14, 2014 5:35 AM by Fred(CH)

    How to format a number on a SQL Query

    Fred(CH)

      Title

      How to format a number on a SQL Query

      Post

           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.