laCond(1)= 'A1A' &&Dept A Sect 1 Unit a laCond(2)= 'A1B' &&Dept A Sect 1 Unit b laCond(3)= 'B1A' &&Dept A Sect 1 Unit a laCond(4)= 'B5G' &&Dept B Sect 5 Unit g ..More array elements lcFilter='' FOR x=1 to alen(laCond) lcFilter=lcFilter+'DSU='+UPPER(laCond(1)) if x<alen(laCond) lcFilter=lcFilter+' OR ' endif ENDFOR SET FILTER TO &lcFilter>I'll try things out and then decide what to use based on the results. Thanks a lot to everyone. It was really helpful. You are the best guys