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
Table24.15.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
Example24.47.Simple Example
Cross a mule with an ass.
SQL> select concat ('Muuli', 'aasi'); callret VARCHAR _______________________________________________________________________________ Muuliaasi 1 Rows. -- 4 msec.