Difference between revisions of "CONCAT()"
From Lianjapedia
Helen.george (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
− | Function to concatenate two strings | + | Function to concatenate two or more strings |
==Syntax== | ==Syntax== | ||
− | CONCAT(<expC1>, <expC2>) | + | CONCAT(<expC1>, <expC2> [, <expCN>...) |
==See Also== | ==See Also== | ||
Line 9: | Line 9: | ||
==Description== | ==Description== | ||
− | The CONCAT() function concatenates the two specified strings, right-trimming | + | The CONCAT() function concatenates the two or more specified strings, right-trimming <expC1>. |
==Example== | ==Example== | ||
Line 18: | Line 18: | ||
</code> | </code> | ||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:String Data Functions]] | [[Category:String Data Functions]] |
Revision as of 07:49, 3 April 2013
Contents
Purpose
Function to concatenate two or more strings
Syntax
CONCAT(<expC1>, <expC2> [, <expCN>...)
See Also
AT(), ATNEXT(), 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)