Hi Hans,

>Hello everybody,
>
>can anybody tell me if the number of elements that you put after the IN filter condition in an sql select (select * from table where field in (element1, element2, ...))is limited ?

It's limited to 24 items.

>And another quesion, I know you can put an sql select after the IN clause (... where field1 in (select field1 from table2)) but can you also give the name of an array ? And if so, how is the syntax?

You cannot use array in IN opearator but you can use ASCAN instead.

SELECT ...
  WHERE ASCAN(laMyarray, field1) > 0 ;
  ....

>
>Hans
>
>PS: I'm (still) using VFP 5.0