Format STMT in a Select

  • Thread starter Thread starter Anthony Acri
  • Start date Start date
A

Anthony Acri

I have set up a select stmt to retrieve fields from a file:

EX; Select tbla.a, tbla.b

field a and b are both numeric 2 decimal.

If say the value is 90.10, it returns 90.1
If say the value is 95.55, it returns 95.55.

I remember you can use the format stmt in the select in order to make sure
you get 2 decimals coming
back even if the last one is zero.

Does anybody remeber the format again?

Would it be Select format(tbla.a,2), format(tbla.b,2) ??????

Thanks for any help
 
Back
Top