Q: Limiting number of rows in a select...

hi, i know this has been posted before, but i can't find it. what is a good way to limit the number of rows returned by a select, like if you only want the first 10 or something? thanks, mickm -- _____________________________________________________________________________ Mickey Mestel mickm@netcom.com -on a beach in thailand to a beautiful, stoned, norwegian woman: "..yeah, it's just another foreign country without ice." -----------------------------------------------------------------------------