PowerCenter
- PowerCenter 10.5
- All Products
CONCAT(first_string, second_string)
Argument
| Required/
Optional
| Description
|
---|---|---|
first_string
| Required
| Any datatype except Binary. The first part of the string you want to concatenate. You can enter any valid transformation expression.
|
second_string
| Required
| Any datatype except Binary. The second part of the string you want to concatenate. You can enter any valid transformation expression.
|
CONCAT( FIRST_NAME, LAST_NAME )
|
|
|
---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CONCAT( CONCAT( FIRST_NAME, ' ' ), LAST_NAME )
|
|
|
---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CONCAT( 'Joan', CONCAT( CHR(39), 's car' ))
Joan's car