CONCAT

Function

Concatenates variables, columns, or literals with string variables.

Syntax

CONCAT {src_any_lit|_var|_col} WITH dst_txt_var[[:$]edit_mask]

Arguments

src_any_lit|_var|_col

Source field to concatenate with dst_txt_var .

dst_txt_var

Result after execution.

edit_mask

Optional edit mask.

Description

The contents of the source field are appended to the end of the destination field.

CONCAT can optionally edit the source field before appending it. To dynamically change an edit mask, place it in a string variable and reference the variable name preceded by a colon (:). (See Edit Masks.)

The source can be a date variable or column. If an edit mask is not specified, the date 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.

Examples

concat &zip_plus_4 with $zip '-xxxx'  ! Edit zip plus 4.
concat &descrip with $rec :$desc_edit ! Edit mask in variable.
concat $date1 with $string            ! Concatenate a date.