>Why VFP5 shows only the first element?, What am I doing wrong?
>select x1, x2 from dbx!tablex ;
> where tablex.x1 in (MyArray)
>
>Thanks.

You'll have to specify each element of the array, or use a UDF that searches the array for you. Your above syntax will not work, as you've already found out.