Hi All,

I am trying to create a screen where the user can select criteria for a report. The problem I am running into is that when I use the 'IN ()' in the WHERE clause there is a limit of 25 items per 'IN'. I might need up to 100+ in some cases. I need to have from 1 to 13 possible 'IN's in the statement. Since we are using the VFP ODBC to access a standard 'DBC' type database. The notion of Stored Proc is out of the question from what I've been told. If the criteria is kept to a minimum everything works fine. But this may not always be the case.

Anybody have an idea of a way to get around this limitation? Will I have to do several queries? If so, at what level do I do the breakdown?

TIA
Mike

P.S. VFP6 SP3