Skip to Content
0
Apr 13, 2010 at 09:51 AM

Concatenate fields with space in between

34 Views

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