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.