>I am having to compare a string with a multiple selected items from a list box.
>Ex:
>
>select all a.cname, b.csemester, b.cccourse, b.cstudent from sysMast a, enroll b where rtrim(b.semester) == thisform.listBox.value(this is a multiple selection list box and I am having to compare
>rtrim(b.semester) with all the item selected in the list box)
>
>How can you do this? can you do a some kind of loop in the select statement.
>
>Thank you for any help

---

I don't think loops are possible.
But you can make a loop to fill in a cursor with the selected items.
Then you can use that cursor for your SQL view.
You also ca do this with a multiselectgrid (grid with a check field).
Posible there is one n the files section.

Hope this helps you