[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

[makdu]

Found the solution

For i = 0 To cno
            notfoundelement = True
            For j = 0 To cno
                If itemname(i) = sortarray(j) Then
                    notfoundelement = False

                End If
            Next
            If notfoundelement = True Then
                sortarray(elementcount) = itemname(i)
                elementcount = elementcount + 1

            End If
        Next