con()

Function group Execute on client Platform(s)
String YES All

Syntax

con(string1,string2[,string3]...)

Description

Returns a string by concatenating two or more string values.

con() has a limit of 100 parameters. You can exceed this limit by using Calculate CVAR1 as con(CVAR2,CVAR3) where CVAR2 has 99 items and CVAR3 has 99 items, and so on.

Example

Calculate lFirstName as 'Dick'
Calculate lLastName as 'Rawkins'
Calculate lName as con(lFirstName,' ',lLastName)
; returns 'Dick Rawkins'


Calculate lResult as con('Omnis',' library')
; returns 'Omnis library'


Calculate lResult as con('May ',8,'th 200',3)
; returns 'May 8th 2003'


; Note the use of spaces in the above examples