Ok, thanks for your response.josh wrote:You'd have to implement this with business logic. I supposed it would do a round to length 2, and then store the field. Float will be fine unless you need to add .00000001 and .00091919 and numbers like that. I would do the rounding in application code but thats just me
Might I also ask, what happens when you add numbers like .00000001, just out of my curiosity?
[EDIT]Making the data type a FLOAT and having php ensure that only 2 digits are allowed does solve my first and second issues. But now all I'm left with is my third issue in my list of criteria, which states that any decimal value should contain two places and no less. Any ideas?