Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to add two zeros end of field

Former Member
0 Kudos
179

how to add two zeros end of field?

6 REPLIES 6

Former Member
0 Kudos
131

what is this field? char? numeric?

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

0 Kudos
131

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
0 Kudos
131

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
0 Kudos
131

hi

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

mahaboob_pathan
Contributor
0 Kudos
131

hi,

declare the type as RBETR.

hope your problem will be solved.

Former Member
0 Kudos
131

thanx