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