AnsweredAssumed Answered

SQL number formatting

Question asked by on Dec 8, 2017
Latest reply on Dec 9, 2017 by beverly

Hello everyone:


I currently have the following executeSQL results below.


Screen Shot 2017-12-08 at 10.53.04 AM.png

I'd like to format the number to 2 decimal places. For now I'm only concentrating on the first field containing the number 2. I'd like to return the value, 2.00.


I've tried formatting the field and that didn't work.


I used the following code:


ExecuteSQL ( "select sum(c_FinalLaborHrsUsed_Line) FROM jobs_PRODLABORCOSTS Where JobID_FK=? group by ContactID_FK"; ""; ""; GetAsText(ID) )


But when I try to use SQL functions like Decimal or Cast, I did not get the desired results:


Any help would be appreciated. Thank you for your help.