Neoview SQL Reference Manual (R2.2)

The concatenation of two string literals.
'ABILENE ' ||' TEXAS'
The concatenation of three string literals to form the literal:
'ABILENE TEXAS USA'
'ABILENE ' ||' TEXAS' || x’55 53 41
The concatenation of a string literal with the value in
column CUSTNAME.
'Customer ' || custname
CAST function applied to a DATE value.
CAST (order_date AS CHAR)
Expressions 209