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