ABAP Keyword Documentation →  ABAP - Reference →  Processing External Data →  ABAP Database Accesses →  Open SQL →  Open SQL - Read Accesses →  SELECT →  SELECT - result →  SELECT - select_list →  SELECT - col_spec →  SELECT - sql_exp 

sql_exp - sql_string

Other versions: 7.31 | 7.40 | 7.54

Syntax

... operand1 && operand2  [&& operand3 ... ] ...

Effect

Character string expression in Open SQL. The operator && chains the character strings in two adjacent operand to a single character string. The operands can have the following data types:

• Dictionary types CHAR, CLNT, CUKY, LANG, and UNIT for columns of database tables or views.

• ABAP type c for host variables.

• Text field literal of type c. Empty text field literals cannot be specified.

The operator && can only be used to chain the elementary operands stated above. Any other expressions cannot be chained. The result of the chaining must be no longer than 255 characters.

Trailing blanks are handled as follows:

• Precisely one blank is respected in host variables declared using CONSTANTS and in text field literals consisting only of blanks.

• In all other cases, trailing blanks are cut off on the right.

The result has the type CHAR in the resulting length and can be assigned to the ABAP types c and string in accordance with the associated assignment rule.

If the operand of a string expression has the null value, the result of the full string expression is the null value.

Example

See SQL Expressions CASE and &&.