Difference between revisions of "CONCAT()"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Helen.george (Talk | contribs) |
||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to concatenate two strings | Function to concatenate two strings | ||
− | |||
==Syntax== | ==Syntax== | ||
CONCAT(<expC1>, <expC2>) | CONCAT(<expC1>, <expC2>) | ||
− | |||
==See Also== | ==See Also== | ||
[[AT()]], [[ATNEXT()]], [[INLIST()]], [[LEFT()]], [[OCCURS()]], [[RAT()]], [[RIGHT()]], [[SET STRESCAPE]], [[STR()]], [[STREXTRACT()]], [[STRSTR()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]] | [[AT()]], [[ATNEXT()]], [[INLIST()]], [[LEFT()]], [[OCCURS()]], [[RAT()]], [[RIGHT()]], [[SET STRESCAPE]], [[STR()]], [[STREXTRACT()]], [[STRSTR()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]] | ||
− | |||
==Description== | ==Description== | ||
The CONCAT() function concatenates the two specified strings, right-trimming both and adding <expC2> to the end of <expC1>. | The CONCAT() function concatenates the two specified strings, right-trimming both and adding <expC2> to the end of <expC1>. | ||
− | |||
==Example== | ==Example== | ||
Line 21: | Line 17: | ||
? concat(concat(city,', '),country) | ? concat(concat(city,', '),country) | ||
</code> | </code> | ||
− | |||
==Products== | ==Products== |
Revision as of 11:34, 11 December 2012
Purpose
Function to concatenate two strings
Syntax
CONCAT(<expC1>, <expC2>)
See Also
AT(), ATNEXT(), INLIST(), LEFT(), OCCURS(), RAT(), RIGHT(), SET STRESCAPE, STR(), STREXTRACT(), STRSTR(), STRTRAN(), STUFF(), SUBSTR()
Description
The CONCAT() function concatenates the two specified strings, right-trimming both and adding <expC2> to the end of <expC1>.
Example
open database southwind use customers ? concat(concat(city,', '),country)
Products
Lianja Server, Lianja