<snip> I then need to return one single random record from that result set for use. Any thoughts on the best way to do this? </snip> what database are you using? most DBs have a random function that you can use -- Lindsay Evans. Production Artist/Coder, Red Square Productions. vox: 8596.4000 fax: 8596.4001 web: www.redsquare.com.au