Hmmm...without knowing any details of the application, my first opinion is that these should not be in 16 fields, but in a separate table (related to the first), containing one record for each piece of equipment. Sounds like your data is not properly normalized.

Another problem with your scheme is that it will crash when you hit 13 fields...255 (or 254?) character limitation per field...unless you are trimming the fields).

How would you split this to rows once it got to the report?

>Yes, so that I can place this field on the VFP report. And then the report will print each equipment name on a separate line. And there will be just as many lines/rows as selected equipment.
>
>>And your goal is to have one very long field that contains all of those results, separated by semi-colons?
>>
>>>Yes, EQ1NAME .. EQ16NAME are fields in a table.
>>>
>>>>Just to be clear...is EQ1NAME the name of a field that exists in the table? IOW, it is not a variable that contains the name of a field.
>>>>