Try using LPAD/RPAD with c_POS_ID as POS_ID is CHAR type column, which will be of fixed length.