SQL> select distinct lpad(floor(cast(MPUNKT as integer)/100),4,'0') from TEST; LPAD =============================================================================== 0001 0002 0017 SQL>