Select numbers with more than 4 decimal places

Question

I have a SQL table with one float column populated with values like these:

  1.4313
  3.35
  2.55467
  6.22456
  3.325

I need to select rows containing only values with more than 4 decimals. In this case, the select must return:

2.55467
6.22456

Ideas? Thanks!

This is what I have tried so far

select * 
from table 
where CAST(LATITUDE AS DECIMAL(10,5)) - LATITUDE = 0

Answer 1

DECLARE @tbl TABLE (val float)
INSERT INTO @tbl SELECT 1234.567
INSERT INTO @tbl SELECT 1234.5678
INSERT INTO @tbl SELECT -1234.5678
INSERT INTO @tbl SELECT 1234.56789

SELECT *
from @tbl
where (((val*10000) - CONVERT(INT,(val*10000))) <> 0)

Answer 2

Why cant we make it simple by this query:-

SELECT * FROM table WHERE val LIKE '%.____%'

This selects what we want