• What is the data type of the AMOUNT column?

    Could it be a MONEY datatype that you are stripping the last 2 digits from to show with 2 decimal places?