Problem in manipulating a record

Hi,

I have a requirement to manipulate a record as follows:

If the record is 22.85 I need to generate the value 0228500 from this
record i.e. I need to take 3 values before the decimal point and 4
values after the decimal point replacing any missing value with a
zero.
I am doing the manipulation as follows:

nvl(lpad(substr (rul.mid_value,0,INSTR(rul.mid_value, '.')-1 ),3,0) ||
rpad(substr (rul.mid_value,INSTR(rul.mid_value, '.')+1,4),
4,0),'0000000')||

Now the issue is that I have a record as 22 which does not have a
decimal point and that is why the above manipulation is failing. The
record cannot be changed and I somehow need to change my manipulation.

Any ideas??

Thanks,
Sandy

.

Relevant Pages