Skip to Content
0
Former Member
Dec 05, 2007 at 12:54 PM

Leading zero problem!

17 Views

Hi !

i have a numeric type variable i.e. 'w_xyz type n length 7'

now i want to delete the leading zero's for this variable simultaneously want to retain the length of the field unaltered i.e.

if w_xyz = '0000987' then i want

w_xyz = ' 987'.

any help pls,

Thanks in advance.

Regards,

Parwez.