|
|
|
|
|
|
Evaluating String Expressions
The result of a string concatenation expression is a string containing the first operand string directly followed by the second.
- If string literals or fixed-length host variables are concatenated, any trailing blanks in the operands are retained.
- If a fixed-length character column value is directly concatenated with another string, any trailing blanks in the column value up to the defined fixed length of the column are retained.
- If a variable-length character column value is directly concatenated with another string, any trailing blanks in the column value up to the actual length of the column value are retained.
- If a fixed-length character value and a variable-length character value are concatenated, the result will be a variable-length character value.
- If either of the operands in a concatenation expression is NULL, the result of the expression is NULL.
 Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se |
|
|
|
|
|
|