ConcatWithParentheses() mvSQL database function in Jitterbit App Builder

Summary

Returns a string that is the result of concatenating two string values with the second value enclosed in parentheses.

Syntax

CONCATWITHPARENTHESES(<string1>, <string2>)

Parameters

string1, string2

A reference to a string column or a literal string.

Returns

The concatenation of the two string values with the second value enclosed in parentheses.

Examples

CONCATWITHPARENTHESES('Total', 'Cost')

Returns

Total(Cost)