>cVar = ""
>for i = 1 to alen(aArray)
> cVar = iif(empty(cVar), '("'+aArray(i)+'"',cVar+',"'+aArray(i)+'"')
>next i
>cVar = cVar + ')'
>select x1, x2 from dbx!tablex ;
> where tablex.x1 in (cVar)
>
>This doesn't work too. I will use UDF.
>
>Thank you very much for your help.

You would have to specify

SELECT .... IN (array[1],array[2],array[3],...)

But the UDF will probably be a better solution for you.