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