Good Day,

I have a field in my database called ism.dept.multiple. This field can contain multiple department names.

Example:

Department of Technology
Department of Economics
Department of Tourism

I use a formula called DeptAffected to split out the entries from the field.

numberVar i := 0;
numberVar j := 0;
stringVar out := " ";
stringVar array test := split({cm3rm1.ism.dept.multiple}, chr(10)+chr(13) );
i := ubound(test);
if i > 0 then
   for j := 1 to i step 1 do
        out := out + UpperCase(test[j]) + ", ";
out


This takes the data and puts it into the field looking like this:

DEPARTMENT OF TECHNOLOGY, DEPARTMENT OF TOURISM, DEPARTMENT OF ECONOMICS

There are records that will not have anything in the ism.dept.multiple field.

I want to be able to record which records have data in the ism.dept.multiple field and which records do not.

If a record has information in the field, I would like it to be True. If a record does not have information in the field, I would like it to be False.

The length of the department names vary from department to department.

What formula can I use to distinguish between a record with departments and a record without?

I am using Crystal Reports 9 with a DB2 database.

Thanks!

Jennifer