thanks BoDurban,
what i actually want to do is return a random record.
I plan to create a cursor with a randNum column that's just an auto-increment column and the ID column containing the key of the row i want to return. that's why i needed the insert select, but i'll try your advice, thanks...