The CONCAT function
accepts two expressions as arguments, and returns a single character
string that appends the string representation of the value returned
by its second argument to the string representation of the value returned
by its first argument.
CONCAT Function
Element
Description
Restrictions
Syntax
expr_1, expr_2
Expressions whose string representations of their
values are to be concatenated
Cannot return a complex, user-defined, or large
object type. If a host variable, it must be long enough to store the
resulting combined strings.
Each
arguments to the CONCAT function can evaluate to a character,
number, or time data type. If either or both of the concatenated
arguments is null, the function returns a NULL value.
Unlike
other built-in string manipulation functions of HCL
OneDB™, the CONCAT function
cannot be overloaded.
CONCAT is the operator function of the concatenation
( || ) operator, For a given pair of expression arguments, CONCAT returns
the same string as that operator returns from the same expressions
as operands. See Concatenation Operator for
additional information about concatenation operations, and for restrictions
on the SQL and Dynamic SQL statements in which you can invoke the CONCAT function.