how to add two zeros end of field

[Former Member]

how to add two zeros end of field?

[Former Member]

what is this field? char? numeric?

if you are looking for solutions it doesnt harm to give the complete picture the first time

[Former Member]

it is a numeric field and length is 4. example my storage location is 0088 .

give me the exact statement because after adding zeros to the end i will eqilise the field to costcenter field.

[Former Member]

Hi srinu,

If it's a number field, then just multiply by 100.

If it's a string, then just use CONCATENATE and add the '00' to your existing string.

Hope this helps.

SL

[Former Member]

hi

Edited by: santhosh kumar on Oct 29, 2008 6:28 AM

[mahaboob_pathan]

hi,

declare the type as RBETR.

hope your problem will be solved.

[Former Member]

thanx