XML Guide

10.5
- 10.5.7
- 10.5.6
- 10.4.0

Back Next

concat

Concatenates two strings.

Syntax

concat ( string1, string2 )

The following table describes the arguments for this function:

Argument	Description
string1	String datatype. Passes the first string to concatenate.
string2	String datatype. Passes the second string to concatenate.

Return Value

String.

If one of the strings is NULL, concat ignores it and returns the other string.

Example

The following expression concatenates FIRSTNAME and LASTNAME:

concat( FIRSTNAME, LASTNAME )

The following table includes example arguments and return values:

FIRSTNAME	LASTNAME	RETURN VALUE
John	Baer	JohnBaer
NULL	Campbell	Campbell
Greg	NULL	Greg
NULL	NULL	NULL

Tip

The concat function does not add spaces to strings. To add a space between two strings, you can write an expression that contains nested concat functions. For example, the following expression adds a space to the end of the first name and concatenates first name to the last name:

concat ( concat ( FIRST_NAME, " " ), LAST_NAME )

The following table shows example arguments and return values:

FIRST_NAME	LAST_NAME	RETURN VALUE
John	Baer	John Baer
NULL	Campbell	Campbell (includes leading space)
Greg	NULL	Greg

Rename Saved Search

Table of Contents

XML Guide

XML Guide

concat

concat

Syntax

Return Value

Example

Tip