Asking what datatype should I used?

[lotus18]

Hello World!

I am currently working on a field that contains 'Prices'
I declared its datatype as double, Length=7 and Decimals=2and it works fine but a problem arises when the decimal contains a fixed .00

This is working:

789.69
56.36
7853.15

When I insert new values

789.00 becomes 789
56.00 becomes 56
7853.00 becomes 7853

Rey Sean

[amitpatel66]

Convert the data in to two decimal places while fetching from the table? What happens in this case?