SQL> select distinct floor(cast(MPUNKT as integer)/100) from TEST; FLOOR ===================== 1 2 17 SQL>