does mysql have an equivalent to Oracle's NUMBER(6,2) ?
for example: NUMBER(5,2) can output 12000.40
it will round to the hundredth

in mysql whats the best type to store currency type digits, like: 80.99 Im thinking of using Decimal. Im really unsure. would anyone like to help me out on this one

Hi

I would use decimal.

As for rounding say you need to round 123456 / 999 to the hundreth I would do

round(123456 / 999 *100) /100

You should get 123.58

Have fun
One line at a time