# 22. Virtuoso Functions Guide - concat

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
Aggregate Functions
Array Manipulation
aref
aset
concat
concatenate
dvector
get_keyword
get_keyword_ucase
isarray
make_array
position
serialize
split_and_decode
tree_md5
vector
vector_concat
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## concat

Concatenate strings
concat ( str1 varchar, str2 varchar, ... , strn varchar);
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.

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.

Errors

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
Simple Example

Cross a mule with an ass.

    SQL> select concat ('Muuli', 'aasi');
    callret
    VARCHAR
    _______________________________________________________________________________

    Muuliaasi

    1 Rows. -- 4 msec.