> > Could someone give me an example of a select * with LIMIT > > used by 6.5?> > SELECT * FROM foobar LIMIT 100
Or you could use ROWCOUNT...
set rowcount = 10select * from table
Regards,
Mark.--Mark JewissKnowledge Matters Limited