+ Concatenation operator

+ Concatenation operator

Produces a character value by joining two character strings or expressions.

Syntax
expression + expression 
expression

An expression whose value is a character string. If any expression is a LONGCHAR, the result is a LONGCHAR. Also, the result converts to the code page of the expression on the left.

Example

The r-conc.p procedure prints mailing labels. It uses the concatenation operator (+) to ensure that the third line of each label shows the city and state separated by a comma and a space. The FORMAT x(16) is specified to provide room for up to 16 characters in the result of the concatenation. If a FORMAT is not given, then the AVM displays only the first eight characters of the result since x(8) is the default format for a character expression.
r-conc.p
FOR EACH Customer NO-LOCK: 
  DISPLAY SKIP(1) Customer.Name SKIP Customer.Address SKIP 
    Customer.City + ", " + Customer.State FORMAT "x(16)" Customer.Country 
    Customer.PostalCode SKIP(2). 
END. 
This is a label produced by this procedure:

Note

If any of the string values you concatenate is the Unknown value (?), then the result is the Unknown value (?). This might lead to unexpected results if a field used in an expression is not mandatory. For example, you might have fields for a person’s first name, last name, and middle initial. You might combine these into a full name with an expression like the following:
DISPLAY fname + " " + minit + " " + lname FORMAT "x(36)". 
If minit is not a mandatory field, it might be set to the Unknown value (?) in some records. If so, then those records are displayed as the Unknown value (?). You can avoid this by using conditional code. For example:
DISPLAY fname + " " + (IF minit <> ? THEN minit + ". " ELSE "") + " " +  
  lname FORMAT "x(36)". 

`expression` + `expression`

r-conc.p
FOR EACH Customer NO-LOCK: DISPLAY SKIP(1) Customer.Name SKIP Customer.Address SKIP Customer.City + ", " + Customer.State FORMAT "x(16)" Customer.Country Customer.PostalCode SKIP(2). END.

DISPLAY fname + " " + minit + " " + lname FORMAT "x(36)".

DISPLAY fname + " " + (IF minit <> ? THEN minit + ". " ELSE "") + " " + lname FORMAT "x(36)".

OpenEdge Release 10.2B