CONCAT

From AgileApps Support Wiki
Revision as of 18:38, 15 April 2010 by imported>Evelyn
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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