Name
concat — Concatenate strings
Synopsis
concat
(
|
str1 varchar , |
| str2 varchar , | |
| ... , | |
strn
varchar
); |
Description
concat
returns a new
string
,
concatenated from a variable number of strings given as
arguments. NULL arguments are handled as empty strings.
concat (str)
returns a copy of
str
.
concat ()
returns an empty string .
Parameters
Concat takes a variable number of string arguments.
Return types
The
concat
returns a single
string
. If there are wide strings
amongst
the arguments, the string returned will also be
wide
.
Errors
Table 24.14. Errors signalled by concat()
| sqlstate | error code | error text |
|---|---|---|
| 22023 | SR007 | Function concat needs a string or NULL as argument <argument number>, not an arg of type <offending type> |
Examples
Example 24.47. Simple Example
Cross a mule with an ass.
SQL> select concat ('Muuli', 'aasi');
callret
VARCHAR
_______________________________________________________________________________
Muuliaasi
1 Rows. -- 4 msec.