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 [,...])

string1

The first string to be concatenated.

string2

The second string to be concatenated.

Example

The following creates a phone number from three fields and includes the constant values.

PHONE_NO = @STRCAT ("(", AREA_CODE,")",PREFIX,"-", PHONE)