Format an SQL string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have some code that has some SQL. This works fine and produces the
results in the usual query window. The data is mainly numbers and I would
like to format the results in the standard number format. At the moment
there are no commas and is at 16 decimal places which is not user friendly.

Can anyone help?

Thanks,

Martin
 
Use the Format() function, posible in your SQL to format the output as
required.

You should post relevant code / SQL with your question so that potential
respondents have some clue of what you are doing.
 
Back
Top