Omnidex SQL Function: CASE

The || (two vertical bars) function returns a single concatenated character string made up of two or more character strings. CHAR||CHAR 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