CONCAT: Concatenating Two Character Strings

How to:

The CONCAT function concatenates the values of two arguments. The result is a character string consisting of the characters of the first argument followed by the characters of the second argument.


Top of page

x
Syntax: How to Concatenate Two Character Strings
CONCAT(arg1, arg2)

where:

arg1, arg2

Character strings

Are the strings to be concatenated.

The length of the result is the sum of the lengths of the two arguments. If either argument is variable-length, so is the result; otherwise, the result is fixed-length.



Example: Concatenating Two Character Strings

CONCAT concatenates two string. This example,

CONCAT('abc', 'def')

returns abcdef.


iWay Software