Progress
Report Builder
User’s Guide


Case Sensitivity

Case sensitivity affects calculated fields in two ways:

How Operators and Functions Case Sensitively Process Data

Operators that process character string values do not apply case sensitivity unless one or more of the operands is case sensitive. This applies to operators, such as greater than (>), that compare character values but do not return them.

Built-in functions do not apply case sensitivity unless one or more arguments is case sensitive. This includes the IIF and CASE functions. If any argument passed to one of these functions is case sensitive, Report Builder processes the whole expression case sensitively.

How Report Builder Determines the Case Sensitivity of Expression Results

Report Builder determines the case sensitivity of expression results by determining:

If the database field in a calculated field expression is case sensitive the result of the subexpression is also case sensitive.

For example, in the calculated field expression:

SUBSTRING (fname,1,5) + lname 

If fname is a case-sensitive database field then the result of the sub-expression SUBSTRING (fname, 1,5) is also case sensitive. The natural case sensitivity of SUBSTRING (fname, 1, 5) + lname is therefore also case sensitive.

See "Fields," for a complete description of how Report Builder handles case sensitivity.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095