Re: Limiting # rows returned by SQL query - during te

From Billy Wheeler: * -> In INFORMIX, I've always used 'where table.rowid < NNN'. * * Yeah, it's just that in OnLine, rowid doesn't start at 1... * * I usually just have a counter in my loops and bomb out when I get to NNN. * Graceful, just like me .... (choke-choke) Just kiddin' ;-) Anyway, that won't work if you have a statement like: INSERT INTO table_name SELECT * FROM other_table WHERE some_conditions_needed_here And others I forgot to mention. Robert Minter Data Systems Support \\\\\\_/// Senior Software Engineer A Client Technologies Company ( _ _ ) E-Mail: rob@dssmktg.com Tel: 714.771.0454 (| ^ |) #include <disclaimer.h> Fax: 714.771.3028 \\`-'/ De Colores - Emmaus OC-13 SURF'S UP \\_/