4.21 STRCAT
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)