Omnidex SQL Function: CASE

The concatenation operator - || (two vertical bars) returns a single concatenated character string made up of two or more character strings. A concatenation operator on two character strings (CHAR_col2 || CHAR_col2) will return a CHAR string; everything else will return a C STRING.

All blanks are preserved during concatenation. Use the TRIM function to eliminate blanks if desired.

[ < column_spec | "string" > || < column_spec | "string " > 
    [ || <column_spec | "string "[...] ]

SELECT company,
CUSTOMERS.LASTNAME || ', ' || CUSTOMERS.FIRSTNAME 
FROM customers 
WHERE company = 'systems'

SELECT
PRODUCTS.PRODUCT_NO || ' is the product number for ' || PRODUCTS.DESCRIPTION
FROM products