Max. records in Range table used in Select .. IN ?

Hi

Does somebody knows wich is the max. amount of records in a RANGES table used in Select Comand:

select xxxx FROM table

where field IN range_table.

That, because i found severeal times programs aborting for this cause, so i changed this condition to an ALL ENTRIES.

Regards

Frank