<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? what database are you using? most DBs have a random function that you can use </snip> Sorry about that, I am using SQL Server 2000. Guy Babbitt Systems Architect P 206.933.4976 C 253.691.2333