Home > Expression Operators > Character Operators > #CONCAT

#CONCAT

Combines two strings.

NOTE: Trailing "spaces" are deleted from the result of the #CONCAT operator. 

Syntax:

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)