con()

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