• Well, if that is the case, I will explain to you how you could implement it.

    You said you wanted to count the number of occurences that had more than 2 decimals.

    Here's how:

    First Method : The modulo method.

    SELECT count(* )

    FROM YourTableName

    WHERE cast((FloatColumnName * 1000) /* that is for 2 decimals*/ AS INT)%10 = 0

    Second Method, compare the rounding of the value with the value itself, to see if there was any more decimals

    SELECT count(* )

    FROM YourTableName

    WHERE round(FloatColumnName,2) FloatColumnName

    Just put in your table name, and your column name, and it will give you the count you were expecting.

    If you need more assistance, please feel free to post your question.

    Cheers,

    J-F