Use the @STRCAT
function to concatenate one or more strings. The string can be either the name of a column or a literal string. Enclose literals within quotes.
Syntax
result = @STRCAT (string1, string2 [,...])
Example
The following creates a phone number from three fields and includes the constant values.
PHONE_NO = @STRCAT ("(", AREA_CODE,")",PREFIX,"-", PHONE)