AnsweredAssumed Answered

SQL Select formatting Number as decimal

Question asked by GiancarloMeak on Mar 19, 2013
Latest reply on Mar 20, 2013 by greglane

I have the following SQL

 

ExecuteSQL (

"SELECT orgName01, field02

FROM table01 WHERE checkBox01 = 1 and id = ?"

;

"" ; ""; table01::id)

 

I'd like to get the number of field02 formatted with a fixed number of decimals of two, but SQL retrieve the raw number unformatted

This could be the result:

Apekta inc. 123,00

Acme inc. 128,10

....

 

Thanks for helping

Gianco

Outcomes