CONCAT

Syntax:

C part_1 CONCAT C part_2

Return Value:

C result

 
Precedence:10
Description:

CONCAT joins two character fields
CONCAT can be used in combination with HEAD and TAIL to concatenate parts of a field

Example:

"HE" CONCAT "LLO" = "HELLO"
"HELLO " CONCAT (HEAD("JOE BROWN",3)) = "HELLO JOE"