Hi Frederico,

I believe, we are talking about VFP here.

Thanks,
Aleksey.


>>>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'
>	)
>