CONCAT

From AgileApps Support Wiki

Jump to: navigation, search

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
Personal tools