CONCAT
From AgileApps Support Wiki
Revision as of 18:38, 15 April 2010 by imported>Evelyn
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 |