Skip to Content
0
Former Member
Dec 18, 2006 at 08:51 AM

Concatenate in Select

43 Views

Hi,

How can I concatenate 3 fields in a select?

I have ..

select

cretim credat updtim upddat docnum status idoctp maxsegnum from

edidc into table it_control

where cretim in timeidoc

and credat in dateidoc

and updtim in timereg

and upddat in datereg

and docnum in numdoc

and status in stat. "latest status for this idoc

I want to concatenate EDIDC-SNDPRT/EDIDC-SNDPFC/EDIDC-SNDPRN in field it_control- aplicacion.

thanks!