Hi Cetin,

I spent a good part of last night doing code to parse my potentially long list into up to 9 lists to do with UNIONs, and that still had me limiting the user to just over 200 items.
This solves it all nicely and simply. Thanks!

By the way, I had looked through the Select-SQL help for the limit initially and didn't find anything. Then, when checking for limitations for UNION there I came across the limit documented at 24.

cheers

>>I know that the VFP function INLIST() has a limitation of 24 items in its list.
>>
>>Does the SQL-Select IN (I1, I2, I3...) have any limit other than VFP's overall line length limit?
>>
>>Thanks
>
>Jim,
>AFAIK IN (...) has 24 limit (1 less than 25 inlist limit).
>Even if it did pass the limit it'd be prone to hit command line length limit.
>Whenever I need such a thing I create a cursor to hold inlist items and use that cursor for IN part. ie:
>
>select .... where myField IN (select ... from tempCursor)
>or :
>select ..... from myTableA a inner join tempCursor b on a.item == b.item ...
>
>ie:
>

>LOCAL lcIDs,lnLines
>local array arrIDs[1]
>lcIds = ;
>'10020,10028,10037,10041,10059,10070,10073,10075,10076,10077,'+;
>'10096,10132,10140,10141,10147,10151,10152,10177,10178,10183,'+;
>'10187,10189,10194,10196,10212,10228,10230,10243,10244,10265,'+;
>'10277,10280,10295,10300,10307,10312,10313,10327,10339,10345,'+;
>'10368,10379,10388,10392,10398,10404,10407,10414,10422,10457,'+;
>'10462,10471,10478,10487,10502,10515,10516,10541,10552,10553,'+;
>'10556,10561,10563,10583,10588,10595,10615,10620,10657,10663,'+;
>'10669,10673,10676,10683,10686,10691,10727,10734,10737,10738,'+;
>'10752,10780,10781,10787,10798,10805,10808,10810,10815,10819,'+;
>'10832,10846,10858,10865,10912,10915,10919,10939,10949,10967,'+;
>'10971,10982,10983,10985,10989,10990,10994,11000,11001,11005,'+;
>'11009,11010,11013,11014,11015,11020,11028,11032,11035,11042'
>
>CREATE CURSOR Idlist (order_id i)
>lnLines = ALINES(arrIds, lcIds,.f.,',')
>DIMENSION arrIDs[lnLines,1]
>APPEND FROM ARRAY arrIDs
>
>SELECT * from orders o ;
>  INNER JOIN IDList il ;
>  ON VAL(o.order_id) = il.order_id

Cetin