How to Concatenate Two Strings

By | July 25, 2016

You may come across the situation, where you want to concatenate a char or CLOB value to a char or CLOB variable. Sage X3 has a special Keyword named APPEND to perform the concatenation of two or more string values.

From a functional point of view, Append Field1, Field2 is equivalent to Field1+= Field2.  if ‘Field1’ and ‘Field2’ are strings or CLOBs. Execution is fast using Append keyword especially if you build long strings stored in CLOBs.

concatenate two strings

The output of the above code is following:

sage X3-concatenate two strings

Also Read:

– Determine Record Size of Tables in X3

– How to get Row count in Sage X3?

– How to get the number of records which is deleted by Delete Command

– How to get the number of records modified by Update Command

– How to determine if a mask variable can be entered or is displayed..?