Format STMT in a Select

[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

 

[Microsoft News Groups]

Format(12.1,"0.00") will return 12.10

Rod Scoullar

 

[Anthony Acri]

Thanks,

I guess will replace 12.1 with the actual field name.

 

[Microsoft News Groups]

That's right.

Rod