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.

[Former Member]

Hi Raymond,

Use '+' between the fields to concatenate them.

Ex:

SELECT T1.CardCodeT1.StreetT1.Block+ T1.City+ T1.ZipCode + T1.State+T1.Country FROM [dbo].[CRD1] T1

Regards,

Sridharan T

[Former Member]

Hi Raymond,

When you create a query (or formatted search), SAP Business One passes the query to the database server.

So if you specify a concatenate function, it validates it against the database server.

Your database should be able to support Concatenate fuction.

Here's what you can do, create a query and run it in your database, make sure you remove survey and form variables before you execute the query.

Laurence Resubal