CONCAT()

From Lianjapedia
Revision as of 10:53, 13 February 2020 by Yvonne.milne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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)
Retrieved from "https://www.lianja.com/doc/index.php?title=CONCAT()&oldid=22938"