#CONCAT
Combines two strings.
NOTE: Trailing "spaces" are deleted from the result of the #CONCAT operator.
string1 #CONCAT string2
Examples:
‘Smith’ #CONCAT ',' #CONCAT ‘John’ equals 'Smith,John' (10 characters)
To insert a "comma" and a "space", use the two character string ", " in the following manner:
‘Smith’ #CONCAT (', ' #CONCAT ‘John’) equals 'Smith, John' (11 characters)
Instead of:
(‘Smith’ #CONCAT ', ') #CONCAT ‘John’ equals 'Smith,John' (10 characters)