Progress
Report Builder
User’s Guide
+ Concatenation
Produces a character value by joining two character strings or expressions.
SYNTAX
expression
An expression whose value is a character string.
EXAMPLEThis expression formats the city, state, and postal code for an address:
NOTE
If any of the string values you concatenate is UNKNOWN, then the result is the UNKNOWN value (?). This might lead to unexpected results if a field used in an expression is not mandatory. For example, you might have fields for a person’s first name, last name, and middle initial. You might combine these into a full name with an expression like the following:
If Mid-Init is not a mandatory field, then in some records Mid-Init can be set to UNKNOWN (?). If so, the result of the expression is UNKNOWN. You can avoid this by using the following expression:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |