Thank you for reply.

you right , INLIST only let you have 24 items in the List. Any way I already have tryied the cursor, but it does not seems to work.

can you take a look at this and tell me,Am I doing anything wrong?

this is what i did:

CREATE CURSOR SQL_Sem (sem_Names C(25))

for i = 1 to thisform.selectedlist.listcount
INSERT INTO SQL_Sem (sem_Names);
VALUES (thisform.selectedlist.ListItem(i))
endfor

select all a.cid, a.cname, b.csemester, b.ccourse, b.ccouroff, b.cstudent from sys_mast a, enroll b where a.cid = b.cstudent and rtrim(b.csemester) in (select sem_Names from SQL_Sem) into dbf c:\attend\temp

when I brows the temp table, it is empty.

thank you again:)