I have 3 fields.
I want to concatenate all the 3 in the same order.
But the concern is for eg if I have dont have the plantdesc it should leave 30 spaces and then put the company code.
Concatenate Plant Plantdesc companycode into value.
with the above statement if plant desc is blank it puts plant and company code together.
Now i am solving my issue using.
value+0(4) = plant.
value+4(30) = plantdesc.
value+34(4) = companycode.
Any faster way of doing it.
CONCATENATE Plant Plantdesc companycode INTO value RESPECTING BLANKS.
Edited by: Andrew83 on Sep 16, 2008 8:59 PM