ErcanOPAK.com

You can use SELECT query below to find numbers with more than two decimal places in SQL:

SELECT Amount FROM YourSQLTable WHERE FLOOR(Amount*100)!=Amount*100

--This will filter the SELECT query to only include data which has more than two decimal places, for example:

--42473.7399
--448.899
--948.6999