Neoview SQL Reference Manual (R2.4)

Examples of Character Value Expressions
These are examples of character value expressions:
DescriptionExpression
Character string literal.
'ABILENE'
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(10))
Expressions 241