Return to FileMaker.com
How to format a number on a SQL Query
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 :
how to modify the query to get theses :
Thank you so much for your help !
PS: I think it is also related to ExecuteSQL returns wrong format for decimal numbers with international system settings.
Retrieving data ...