CONCAT()
From Lianjapedia
Contents
Purpose
Function to concatenate two or more strings
Syntax
CONCAT(<expC1>, <expC2> [, <expCN>...)
See Also
AT(), ATNEXT(), FORMAT(), INLIST(), LEFT(), OCCURS(), RAT(), RIGHT(), SET STRESCAPE, STR(), STREXTRACT(), STRSTR(), STRTRAN(), STUFF(), SUBSTR()
Description
The CONCAT() function concatenates the two or more specified strings, right-trimming <expC1>.
Example
open database southwind use customers ? concat(concat(city,', '),country)