Use 'IN ()' IN SQL statement, it allows unlimited number of items, like following:
SELECT ... WHERE MyField IN ("value1","Value2",...,"value50")

In the sample below rtrim(b.csemester) is incorrerct. Do not use rtrim function in that case. Just assure length of csemester field match to length of sem_Names field.


>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:)