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)