Jim Metcalf
asked on
identify data values with 3 numbers after decimal point instead of the desired 2
help identifying values in a table.
i have a table with a column called transaction amt. this column is (money, int) datatype
unfortunately, there are some money transactions have partial pennies showing up. ie... transaction amount might be 59.787. we only need 2 decimal places
does anyone know how to find all transactions where there are 3 digits after the decimal point instead of the desired 2.
i have a table with a column called transaction amt. this column is (money, int) datatype
unfortunately, there are some money transactions have partial pennies showing up. ie... transaction amount might be 59.787. we only need 2 decimal places
does anyone know how to find all transactions where there are 3 digits after the decimal point instead of the desired 2.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Why it works:
% is remainder after division (modulus). The modulus result must be smaller than the divisor, in this case 0.01. So it shows you any values below .01 that are not 0, i.e., thousandths.
For example:
31 % 4 = 3, because that's the remainder after dividing 31 by 4.
% is remainder after division (modulus). The modulus result must be smaller than the divisor, in this case 0.01. So it shows you any values below .01 that are not 0, i.e., thousandths.
For example:
31 % 4 = 3, because that's the remainder after dividing 31 by 4.
ASKER
Thanks Scott!