HI Experts,
I have a requirement where I need to concatenate 4 fields Comapny Code say 000, Doc. Number say 111, Item number say 222 and Fiscal year say 2010.
Such that the resultant field is "000 1112222010"
How can I add this Extra Space.
As Itried this code but it doesn't give me the extra space.
CONCATENATE comp_code ' '
ac_doc_no
fiscyear
item_num INTO obj_type.
Quick response will be highly appreciated.
Thanks
Shubh