CONCAT

From LongJump Support Wiki

The CONCAT function joins two strings into a single string.

Syntax

CONCAT(string1, string2)

Return

String

Examples

Combine two text strings:

CONCAT('Mary','Jo') = 'MaryJo'

Convert a number to an integer:

CONCAT (numberOfItems, '')

    where: 
          numberOfItems is a numeric field
          '' is two single quote (') characters