CONCAT Function

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

1  CONCAT ( expr_1 , expr_2 )
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. Expression

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.