Basically, never ever ever ever make any assumptions whatsoever about the order of rows in a table. Period. I don't have a specific answer for you because there are way too many variables. An ORDER BY is the ONLY way to guarantee the order of results. DRILL that into that developer's head until they bleed .

'nuff said,

- Chris