[RESOLVED] finding distinct element from an array

[makdu]

Hi,
i have an array with wild character at the end. I use the value in this array in Select statment. Some times the array has same values. I want only distinct values in the array before the select statment. Can some one throw an idea on how to do this

for i=0 to count
select * from tbl where item like ' " & itemname(i) & "'
next

I need distinct element in itemname array