Ansicht
Dokumentation

ABENSQL_EXPR_CASE_STRING_ABEXA - SQL EXPR CASE STRING ABEXA

- Simple CASE

This example demonstrates simple case distinctions in SQL expressions.

Source Code

Execute

Description

In a list of columns specified after SELECT, CASE is used to make a simple case distinction for the content of a column. The result is a character string that is concatenated from column content or taken from a host variable. Using the alias name defined after AS, the result is assigned to the identically named column in an internal table declared inline, results.