Ansicht
Dokumentation

ABENSQL_EXPR_STRING_ABEXA - SQL EXPR STRING ABEXA

- Concatenations

This example demonstrates how strings are concatenated in SQL expressions.

Source Code

Execute

Description

In a SELECT list, two columns of a result set of a query are created using concatenations of strings.

• The first column key cannot be created using the operator &&. The column CONNID does not have the required data type and cast expressions cannot be used either. The built-in function CONCAT is used instead.

• The second column connection can be constructed from columns and literals using the operator &&.