Truncating Numeric Field

[Former Member]

Hi all,

i want to truncate extra spaces from salary field...can anyone help me with the code?

i can do it if it is a string.but how i will do with integers???

Merlin

[Former Member]

Your solution will likely be to move the field to a string field for display and/or manipulation.

[Former Member]

Hi,

Better move it to a char/string type field and condense.

reward if helpful.

Regards,

ramya

[Former Member]

do this way ...

data : v_inte type i value '100 01',
         v_char(10),
         v_final type i.

 v_char = v_inte.
condense v_char no-gaps.
v_final = v_char.
write v_final.  

Regards,

Santosh

Edited by: Santosh Kumar Patha on Mar 17, 2008 4:56 PM