Concetanate

[Former Member]

Hi, can we use concatenate in SAP to combine several text field together?

I tried to use add a formatted search to combine Address (Line 1, Line 2, Line 3 of BP) of a vendor together in the OVPM,address (outgoing payment). That means when I pick Vendor A, then it will show that vendor address.

However, it seems that there is no "concatenate" function in SAP. Do you know how to do it?

Thanks.

Raymond

[Former Member · Accepted solution]

Raymond,

Sridharan is true. If you want to have the result more readable in more lines, use it as

SELECT T1.CardCode + char(10) + char(13) + T1.Street FROM dbo.CRD1 T1

But be in mind, that at the end you should reflect the size of field where you want to write the result (it cannot exceed). For this use LEFT function.