Concatenates the values indicated in the @val parameters into a single String. If these parameters are not String data types, an attempt on automatic conversion is then performed. If only one parameter is provided, the effect is converting that parameter to a String.

Syntax

CONCAT(@val_1[, @val_n])

Parameters

•@val_1: Value of position 1 (one). This is a mandatory parameter

•@val_n: Value of position n, in which n is greater or equal to 2 (two). The limit of parameters is undefined