concat

Description Syntax Parameters Returns Example
Concatenates string values. concat(strExpr) strExpr: string expressions(1 to n) String, which is a concatenation of all input strings. concat('PREFIX-','STRING','-SUFFIX')


concat('PREFIX-',rpad(PRODUCT_NUMBER, 9, 'A'),'-SUFFIX')