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.
>>>
>>>>Steve,
>>>>
>>>>Typically EQ1 through EQ16 would have .F. or .T. (obviously).
>>>>EQ1NAME through EQ16NAME are C-type fields of 20 char long. They maybe blank or some could have entries. For example, user looks at a form where he/she sees all equipment available and check box to select what he/she wants:
>>>>EQ1NAME EQ1
>>>>EQ2NAME EQ2
>>>>... and so on.
>>>>
>>>>On the report I need to show the selected equipment in a column, excluding all the ones thate were not selected. That's why I need the SQL select.
>>>>
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham