This is an old revision of the document!
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