CONCAT
From LongJump 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
|