>>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
>
>Yes, SQL-Select IN (I1, I2, I3...) has the same limit.


No it doesn't. e.g. this works just fine - there's 91 items there

Use Northwind

select * from Customers where CustomerId in (
	'ALFKI',
	'ANATR',
	'ANTON',
	'AROUT',
	'BERGS',
	'BLAUS',
	'BLONP',
	'BOLID',
	'BONAP',
	'BSBEV',
	'CACTU',
	'CENTC',
	'CHOPS',
	'CONSH',
	'DRACD',
	'DUMON',
	'EASTC',
	'ERNSH',
	'FISSA',
	'FOLIG',
	'FOLKO',
	'FRANK',
	'FRANR',
	'FRANS',
	'FURIB',
	'GALED',
	'GODOS',
	'KOENE',
	'LACOR',
	'LAMAI',
	'LEHMS',
	'MAGAA',
	'MAISD',
	'MORGK',
	'NORTS',
	'OCEAN',
	'OTTIK',
	'PARIS',
	'PERIC',
	'PICCO',
	'PRINI',
	'QUICK',
	'RANCH',
	'REGGC',
	'RICSU',
	'ROMEY',
	'SANTG',
	'SEVES',
	'SIMOB',
	'SPECD',
	'SUPRD',
	'TOMSP',
	'TORTU',
	'VAFFE',
	'VICTE',
	'VINET',
	'WANDK',
	'WARTH',
	'WILMK',
	'WOLZA',
	'OLDWO',
	'BOTTM',
	'LAUGB',
	'LETSS',
	'HUNGO',
	'GROSR',
	'SAVEA',
	'ISLAT',
	'LILAS',
	'THECR',
	'RATTC',
	'LINOD',
	'GREAL',
	'HUNGC',
	'LONEP',
	'THEBI',
	'MEREP',
	'HANAR',
	'QUEDE',
	'RICAR',
	'COMMI',
	'FAMIA',
	'GOURL',
	'QUEEN',
	'TRADH',
	'WELLI',
	'HILAA',
	'LAZYK',
	'TRAIH',
	'WHITC',
	'SPLIR'
	)