Concatenates a list of variables, columns, or literals into a single text variable. Each member of the list is separated by the specified delimiter string.
One or more fields to concatenate, separated by the delim_txt_lit|_var|_col character or characters, and placed into the dst_txt_var variable.
If the source is a date variable or column, it is converted to a string according to the following rules:
For DATETIME columns and Production Reporting DATE variables, Production Reporting uses the format specified by SQR_DB_DATE_FORMAT. If not set, Production Reporting uses the first database-dependent format in Table 61, Default Formats by Database.
For DATE columns, Production Reporting uses the format specified by SQR_DB_DATE_ONLY_FORMAT. If not set, Production Reporting uses the format in Table 62, DATE Column Formats.
For TIME columns, Production Reporting uses the format specified by SQR_DB_TIME_ONLY_FORMAT. If not set, Production Reporting uses the format in Table 63, TIME Column Formats.
Characters used as separators between source fields.
The destination field for the concatenated result.
Do no include the destination string in the list of source strings.
string &cust_num &entry-date &total by ',' into $cust-data ! Result: 100014,12-MAR-89,127 ! Use null delimiter.
The “||” concatenation operator in Table 45, Operatorsunder LET