• How did you 'define' your decimal field? The proper syntax is:

    DECIMAL(p,s)

    p=precision - the number of digits total

    s=scale - number of digits to the right of the decimal.

    So, to be able to store your numbers

    2.5, 3.125, 4.1275

    you would need a decimal column as:

    DECIMAL(5,4)

    -SQLBill