Concat function

To concatenate two strings including a separator if desired.

Syntax

Concat(character-expression₁, character-expression₂, [ ,character-expression₃ ] )

character-expression1 + character-expression2 

Type Returned:
Character

Where:
character-expression₃
Is the separator between character-expression₁ and character-expression₂

+ (plus sign)

Description

Returns a String that results from the concatenation of character-expression₁ and character-expression₂> and separator character-expression₃. Trailing blanks of string character-expression₁ are truncated. If character-expression₃ is not specified, no separator is inserted.

Note

In the iSeries, if the strings character-expression1, character-expression2 or character-expression3 are substituted with functions (substr(), str(), etc), then the returned value is null, because the returned values of these functions are 256-character-long variables.

Examples

LastName  = 'SMITH '
FirstName = 'JOHN '
&FullName  = Concat(FirstName,LastName,' ')

Result: &FullName = 'JOHN SMITH '

In case you want to maintain the trailing blanks in the first parameter, you may change the order of the parameters. For example:

LastName  = 'SMITH'
FirstName = 'JOHN '
&FullName = Concat(,LastName,FirstName)

With the plus sign, the concatenation is very simple:

&FullName  = &Firstname + ' ' + &Lastname

Result: &FullName = 'JOHN SMITH'

See also

Str function
Substr function