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
gvector_digit_sort
gvector_sort
isarray
make_array
position
rowvector_digit_sort
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
Phrases
RDF data
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
VAD
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web & Internet
XML
XPATH & XQUERY

Functions Index

concat

Concatenate strings
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
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.